SQL exercises
Filter by difficulty, topic, or the business database behind the question. Progress stays on this device until you create an account.
Loading exercises…
Filter by difficulty, topic, or the business database behind the question. Progress stays on this device until you create an account.
Loading exercises…
Sum the open bills for each vendor.
Finance · 12 min
JOINs · GROUP BY · Data cleaning
Start challengeSum billed and paid claim amounts for each department.
Healthcare · 14 min
JOINs · GROUP BY
Start challengeFind product categories whose average order-line total is at least 10000 cents.
E-commerce · 14 min
JOINs · GROUP BY · HAVING
Start challengeKeep departments whose current headcount is greater than two.
HR · 10 min
JOINs · GROUP BY · HAVING
Start challengeFind workspaces whose most recent invoice is not paid.
SaaS · 16 min
Subqueries · JOINs
Start challengeList posted expense debits larger than the average posted expense debit.
Finance · 16 min
JOINs · Subqueries · Data cleaning
Start challengeFind patients who have more than one encounter.
Healthcare · 12 min
JOINs · GROUP BY · HAVING · Data cleaning
Start challengeList visits whose start date falls in March 2025.
Healthcare · 8 min
WHERE · Date functions
Start challengeShow every ledger memo with spaces removed and blanks labeled.
Finance · 10 min
Data cleaning · NULL handling
Start challenge