Problem Solving

Reusable patterns for the questions that show up again and again.

1. 26Top N
2. 27Top N per group
3. 28The second highest salary
4. 29Duplicate detection
5. 30Missing records
6. 31Consecutive dates
7. 32Conditional aggregation
8. 33Anti-joins and existence checks