Free SQL practice for aspiring data analysts
8 hands-on challenges on a real sales table. Write the query, run it right in your browser, and see if your numbers match. No sign-up, no install.
sales12 orders from NovaRetail, a home appliance retailer selling in the USA, Canada and Mexico. Same data as the Workyp Data Analyst track.
Your manager wants a quick look at what we sell. List every sale with its product and its amount.
Expected output
| product | amount |
|---|---|
| Vacuum X | 349 |
| Vacuum X | 349 |
| Coffee Maker Pro | 129.5 |
| Coffee Maker Pro | 129.5 |
| Stand Mixer | 599 |
+ 7 more rows
The Canada sales lead is on the phone. Pull every sale shipped to Canada, with its id, product and amount.
Expected output
| id | product | amount |
|---|---|---|
| 2 | Vacuum X | 349 |
| 5 | Stand Mixer | 599 |
| 9 | Stand Mixer | 599 |
| 10 | Coffee Maker Pro | 129.5 |
Before Monday's meeting, show the 3 most recent sales: id, product and sale_date, newest first.
Expected output, in this order
| id | product | sale_date |
|---|---|---|
| 12 | Vacuum X | 2026-03-21 |
| 11 | Toaster S | 2026-03-14 |
| 10 | Coffee Maker Pro | 2026-03-09 |
Workyp Training · Data Analyst
In the free Data Analyst track, you join NovaRetail's data team: fix a broken Finance dashboard, cut through vague requests and present to the execs. Real missions, a mentor, instant feedback.
Free account · No credit card
The CFO wants two numbers in a single row: how many sales we made (orders) and our total revenue (revenue).
Expected output
| orders | revenue |
|---|---|
| 12 | 3681.3 |
The Finance dashboard needs one line per country, with that country's total revenue.
Expected output
| country | revenue |
|---|---|
| Canada | 1676.5 |
| Mexico | 528.4 |
| USA | 1476.4 |
Which products brought in more than $1,000 in total? Show each product with its revenue.
Expected output
| product | revenue |
|---|---|
| Stand Mixer | 1797 |
| Vacuum X | 1396 |
How much did we sell in March 2026? Return a single number.
Expected output
| revenue |
|---|
| 1177.3 |
Which countries generate more revenue than the average country? Show each one with its revenue.
Expected output
| country | revenue |
|---|---|
| Canada | 1676.5 |
| USA | 1476.4 |
Workyp Training · Data Analyst
The Data Analyst track on Workyp Training puts your SQL to work: tickets, stakeholders, dashboards, and a certificate you can add to LinkedIn.
Free account · No credit card
No. Every query runs right in your browser on SQLite. Nothing to install, and your queries never leave your device.
Yes. The 8 challenges need no account. The full Data Analyst track on Workyp Training is free too: you just create a free account to save your progress.
SQLite. What you practice here (SELECT, WHERE, ORDER BY, GROUP BY, HAVING, CTEs) carries over to PostgreSQL, MySQL, BigQuery and Snowflake.
In your browser. Come back on the same device and your solved challenges and drafts are still there.