A fun way to practice using joins, window functions, subqueries, common table expressions, and more, including documentation of my logic and multiple solutions in certain cases. All SQL queries are written in MySQL.
Click on this link to view the PDF file containing the questions for the puzzles, then click on any of the .sql files in this repository to view the queries that I wrote, which solve that puzzle. Each .sql file is numbered to correspond with the problem number found in the PDF file.
- Puzzle #17 - De-Grouping
- Puzzle #24 - Page Views
- Puzzle #27 - Delete the Duplicates
- Puzzle #30 - Select Star