Hard SQL interview questions test the advanced problem solving skills expected in many medium and senior level data analyst roles. The first challenge uses ROW NUMBER with PARTITION BY, a subquery, ...