Dear interviewers, I believe hiring process included SQL round whether a candidate can write SQL queries and to asses whether he can analyze business use case(which involves so many discussions with Ppm’s and architects and stakeholders to discuss each and every field in a dataset or table) into real application or not. But i have seen some interviewers come up with some schema which all tables have the same col names like id in products table and sales table and they don’t even care to explain what is in it. Just throws 5 SQL questions and asks you to solve it in coder pad. I don’t understand the point when you didn’t give full context on the question how come you’ll expect the candidate to solve all 5, adding to that they’ll reject you even if you try to solve 3 in 25 mins.. Please do an interview as you’re going to hire the candidate, don’t do it as it is another email/interview from your recruiting team. #sqlinterview
I never understood time limit for solving a problem. How fast you can solve a problem does not tell you anything about a candidate.
Sometimes I get rejected from unqualified company or interviewers. That is common and I personally think that’s a blessing somehow. That’s really the company I should avoid joining.
Doordash straight up said to me that passing the interview requires correct answers. And basically just did exactly what you described in your post. I asked counter questions for context but the interviewer had no clue about the context framing I was trying to get to. It was the dumbest interview in my whole life. Not to mention I didn’t get to next round even after writing queries for 4 question and halfway into fifth in 30 mins. Been writing SQL for 13 years. The interviewer probably only 3 years.
Was it Facebook?