Advanced SQL Practice (MySQL)

A practice-first SQL workbook with 1400+ questions — built to help you go from basic to advanced using real prompts and reference solutions.

Quick links

• GitHub Repo
• Quickstart (setup + smoke test)
• Exercise Index
• Solutions

Topics covered

• Subqueries + EXISTS
• Correlated subqueries
• Window functions (ranking + frames)
• LAG / LEAD
• CTEs (multi-CTE)
• Recursive CTEs (numbers + hierarchy)
• Date/Time functions

Want to suggest improvements? Open an issue or reach out on LinkedIn.