Learn SQL by doing
Work through 250 interactive SQL exercises in your browser. Query a record shop database and get feedback on each answer.
SELECT title, price
FROM albums
WHERE genre = 'Jazz';| title | price |
|---|---|
| Night Bus | 18 |
| Blue Hour | 16 |
SQL guides with examples
SQL SELECT and WHERE for beginners
Use SELECT, WHERE, and ORDER BY to produce a short list of affordable albums that are in stock.
SQL joins explained visually
Switch between INNER, LEFT, RIGHT, and FULL JOIN to see which album and sale rows appear in the result.
GROUP BY vs ORDER BY, explained visually
Compare sorting album rows, combining them into genre totals, and sorting those totals.
SQL window functions with examples
Show each album alongside average stock for its genre with AVG and PARTITION BY.
