SQL Interview Queries Practice Guide - Employee Questions, Joins, and 100+ Challenges
A practical guide to practicing SQL interview queries using employee tables, join questions, blog analytics, and a workshop packed with 100+ runnable prompts.
Why this workshop exists
SQL interviews usually circle the same core patterns: employee questions, joins, group by, having, and a few window functions when the company wants to turn up the heat. The best way to prepare is not by reading answers in isolation, but by running them against a small schema until the shapes start to feel obvious.
What to practice first
- Employee tables: headcount, salary filters, manager self-joins, department averages, and above-average earners.
- Join questions: users to orders, order items to products, posts to tags, comments to posts.
- Advanced questions: top row per group, running totals, cumulative views, and revenue share.
Recommended practice path
- Start with easy HR prompts to warm up on SELECT, WHERE, and ORDER BY.
- Move to medium join and GROUP BY questions across e-commerce tables.
- Finish with hard window-function and reporting prompts on the blog analytics schema.
Open the workshop
The SQL Workshop on this site includes more than 100 prompts across HR, e-commerce, and blog datasets, split into easy, medium, and hard so you can warm up properly before jumping into ranking and reporting questions.
Open the SQL Workshop and start with the HR pack if you want the most interview-like practice path.