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 PostgreSQL and are solutions to Freemium puzzles found on StrataScratch.
I've organized my solutions into folders, based on difficulty level: Easy, Medium, and Hard. Once inside any folder, click on a .sql file to view the problem statement, the corresponding link to the StrataScratch website for that puzzle, and the query I've written to solve it.