SQLRepPracticeGuidesPlaygroundLearning path

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. 1. Your first querySELECT * · FROM · SQL BasicsUp next
  2. 2. Customer directorySELECT · ORDER BY · SQL BasicsFree
  3. 3. Active Canadian customersWHERE · AND · SQL BasicsFree
  4. 4. North American customers who stayedOR · NOT · parentheses · SQL BasicsFree
  5. 5. Customers with a .ca emailLIKE · wildcards · SQL BasicsFree
  6. 6. First-week shipmentsIN · BETWEEN · SQL BasicsFree
  7. 7. Three biggest ordersORDER BY · LIMIT · SQL BasicsFree
  8. 8. Countries with active customersSELECT DISTINCT · SQL BasicsFree
  9. 9. Monthly payAS aliases · calculated columns · SQL BasicsFree
  10. 10. Payments that break the rulesValidation rules · OR · NULL-safe checks · Database AnalystPro