Meta Data Scientist interview questions

Low offer: Their final offer is 50-60K lower than what I was told originally. So the business is definitely struggling. Inappropriate conduct with candidates: One of the interviewers spent 10 minutes pressing me on a question about a subtraction function(A,B). It's either A-B or B-A. I didn't remember, so I said we could look at the documentation. After not getting the answer for a couple minutes, this person got frustrated and yelled at me "I'm the documentation. I'm telling you that..." I was shocked that an interviewer could behave this way. Variable skills among interviewers: There are definitely strong technical people, but the data scientists' skills vary greatly. One was struggling to understand how AVG(CASE WHEN ....THEN 1 ELSE 0 END) could calculate the % of certain condition. I was in disbelief.