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…
Show parcels that have left the warehouse and have not been delivered or cancelled.
Logistics · 6 min
SELECT · WHERE
Start challengeAttach each order line to its product and compute the line total.
E-commerce · 12 min
SELECT · JOINs
Start challengeSum recognized revenue for each product category.
E-commerce · 14 min
JOINs · GROUP BY
Start challengeFind customers with at least two orders that were not cancelled.
E-commerce · 14 min
JOINs · GROUP BY · HAVING
Start challengePair every employee with the department they sit in.
HR · 10 min
JOINs · SELECT
Start challengeList employees whose latest salary is above the average latest salary.
HR · 18 min
JOINs · Subqueries
Start challengeTotal every invoice issued to each workspace.
SaaS · 12 min
JOINs · GROUP BY
Start challengeCount students enrolled in each course.
University · 12 min
JOINs · GROUP BY
Start challengeCount shipments per warehouse, excluding cancelled freight.
Logistics · 12 min
JOINs · GROUP BY
Start challenge