Practice by topic · 10 drills
Selecting & filtering
SELECT, WHERE, AND/OR, LIKE, IN, BETWEEN, sorting and LIMIT: getting exactly the rows you need. Ordered easiest first.
Start: Your first query 0/10 solved
- 1. Your first querySELECT * · FROM · SQL BasicsUp next
- 2. Customer directorySELECT · ORDER BY · SQL BasicsFree
- 3. Active Canadian customersWHERE · AND · SQL BasicsFree
- 4. North American customers who stayedOR · NOT · parentheses · SQL BasicsFree
- 5. Customers with a .ca emailLIKE · wildcards · SQL BasicsFree
- 6. First-week shipmentsIN · BETWEEN · SQL BasicsFree
- 7. Three biggest ordersORDER BY · LIMIT · SQL BasicsFree
- 8. Countries with active customersSELECT DISTINCT · SQL BasicsFree
- 9. Monthly payAS aliases · calculated columns · SQL BasicsFree
- 10. Payments that break the rulesValidation rules · OR · NULL-safe checks · Database AnalystPro