Free SQL challenges

Practice SQL. Run queries in your browser.

17 problems against a realistic Indian D2C retail schema — customers, products, orders, order items. SELECT, JOIN, GROUP BY, and window functions. Runs on SQLite compiled to WebAssembly. No install. No login. No per-run cost.

6
Easy
7
Medium
4
Hard

Difficulty

Topic

Showing 17 of 17 problems

Problem	Topic	Difficulty	Action
01. List every customer SELECTEasy	SELECT	Easy	Solve →
02. Just name and city SELECTEasy	SELECT	Easy	Solve →
03. Filter — Mumbai customers only WHEREEasy	WHERE	Easy	Solve →
04. Cheapest product first ORDER BYEasy	ORDER BY	Easy	Solve →
05. Top 3 most expensive products ORDER BYEasy	ORDER BY	Easy	Solve →
06. Count customers per city GROUP BYEasy	GROUP BY	Easy	Solve →
07. Which customer placed each order? JOINMedium	JOIN	Medium	Solve →
08. Every order line, with product + customer JOINMedium	JOIN	Medium	Solve →
09. Compute line revenue AggregationMedium	Aggregation	Medium	Solve →
10. Revenue per city GROUP BYMedium	GROUP BY	Medium	Solve →
11. Cities with 3+ customers GROUP BYMedium	GROUP BY	Medium	Solve →
12. Customers who have never ordered JOINMedium	JOIN	Medium	Solve →
13. Which categories has each city bought? JOINMedium	JOIN	Medium	Solve →
14. Top-selling product per city WindowHard	Window	Hard	Solve →
15. Running order revenue over time WindowHard	Window	Hard	Solve →
16. Repeat customers only AggregationHard	Aggregation	Hard	Solve →
17. Capstone — analyst summary CapstoneHard	Capstone	Hard	Solve →

Want structure?

Watch a raw CSV become a Power BI dashboard — LIVE.

Our free 90-minute masterclass shows Claude writing SQL while you watch, plus the validation discipline that keeps AI from lying to stakeholders.

Free masterclass Data Analysis with Gen AI Program

Free SQL challenges

Practice SQL. Run queries in your browser.

6
Easy
7
Medium
4
Hard

Difficulty

Topic

Showing 17 of 17 problems

Problem	Topic	Difficulty	Action
01. List every customer SELECTEasy	SELECT	Easy	Solve →
02. Just name and city SELECTEasy	SELECT	Easy	Solve →
03. Filter — Mumbai customers only WHEREEasy	WHERE	Easy	Solve →
04. Cheapest product first ORDER BYEasy	ORDER BY	Easy	Solve →
05. Top 3 most expensive products ORDER BYEasy	ORDER BY	Easy	Solve →
06. Count customers per city GROUP BYEasy	GROUP BY	Easy	Solve →
07. Which customer placed each order? JOINMedium	JOIN	Medium	Solve →
08. Every order line, with product + customer JOINMedium	JOIN	Medium	Solve →
09. Compute line revenue AggregationMedium	Aggregation	Medium	Solve →
10. Revenue per city GROUP BYMedium	GROUP BY	Medium	Solve →
11. Cities with 3+ customers GROUP BYMedium	GROUP BY	Medium	Solve →
12. Customers who have never ordered JOINMedium	JOIN	Medium	Solve →
13. Which categories has each city bought? JOINMedium	JOIN	Medium	Solve →
14. Top-selling product per city WindowHard	Window	Hard	Solve →
15. Running order revenue over time WindowHard	Window	Hard	Solve →
16. Repeat customers only AggregationHard	Aggregation	Hard	Solve →
17. Capstone — analyst summary CapstoneHard	Capstone	Hard	Solve →

Want structure?

Watch a raw CSV become a Power BI dashboard — LIVE.

Our free 90-minute masterclass shows Claude writing SQL while you watch, plus the validation discipline that keeps AI from lying to stakeholders.

Free masterclass Data Analysis with Gen AI Program

Practice SQL. Run queries in your browser.

Watch a raw CSV become a Power BI dashboard — LIVE.

Request your admission

Practice SQL. Run queries in your browser.

Watch a raw CSV become a Power BI dashboard — LIVE.

Request your admission