I was given a case study related to Netflix Gift Cards and was asked to write SQL queries for the given questions. The interviewer expects you to have an optimized query.

I had 8 interviews over a 7 week period for a position which I was told I could do remotely. After all 8 interviews I was told although I was the most qualified they didn't want the job to be done remotely. Absolute waste of time