Microsoft Senior Applied Scientist interview questions

The whole process was very unprofessional. They They were so arrogant and did not respect the candidate. They were asking to write the formula of the sigmoid function. SQL questions like highest salard, I answered it correctly because I have done it many time and later ran it and it was correct but the interviewer insisting that is not a correct answer.