9 SQL Interview Questions That Show Whether You've Actually Queried Production Data

The question that ended a candidate's loop last spring wasn't hard. I asked him to find the second-highest salary in an employees table. He wrote ORDER BY salary DESC LIMIT 1 OFFSET 1, and when I aske