Applied through a referral. Shortly after, a recruiter responded to set up the first round of the interview process, which was a technical screen. This was done in SQL and Python through a shared text editor (that is, both the interviewer and interviewee can see what each person is typing). The questions were quite easy and very straight forward. Made a few minor slip ups here and there (something that can easily be caught in a real-life situation when you'd be able to see outputs or error messages). Here's where I believe the assessment was unfair. There was no specification on which variant of SQL this interview would be conducted in. I coded up my SQL commands in PostgreSQL, but there are slight variations in some of the functions/syntax across different SQL languages. Despite that what I coded was 100% correct in PostgreSQL, because it didn't work with Presto, the interviewer deemed it incorrect. The interviewer was also clearly copying the query I wrote into the editor to verify, so that's why she must have thought I was wrong. So despite writing a completely working query for each of the questions, because it did not conform with one specific variant of SQL, I did not make it to the next round. The number of changes needed to even get it to a working state were so minor too. At least 95% of the query was exactly as she expected it to be. Honestly I was very surprised I didn't move forward... It seems she expected everything to run 100% correctly with no typos or errors despite me not being able to run the code to see the output. Absolutely unfair interview process.