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…
Find invoices that are still open.
SaaS · 6 min
SELECT · WHERE
Start challengeReturn vendor names with surrounding spaces removed.
Finance · 8 min
SELECT · Data cleaning
Start challengeMap messy sex values onto a single-letter code.
Healthcare · 10 min
SELECT · Case statements · Data cleaning
Start challengeList every product, grouped visually by category and then by name.
E-commerce · 6 min
SELECT · ORDER BY
Start challengeAttach each bill to a cleaned vendor name.
Finance · 10 min
JOINs · Data cleaning
Start challengeShow each claim beside the patient it belongs to.
Healthcare · 12 min
JOINs · Data cleaning
Start challengeMeasure how many days each delivered shipment took.
Logistics · 12 min
Date functions · WHERE
Start challengeCount current employees in each department.
HR · 10 min
JOINs · GROUP BY
Start challengeSum monthly recurring revenue for subscriptions that are still active.
SaaS · 10 min
WHERE · GROUP BY
Start challenge