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…
Count the leads captured by each campaign.
Marketing · 10 min
JOINs · GROUP BY
Start challengeTranslate raw order statuses into the words support shows customers.
E-commerce · 10 min
Case statements · SELECT
Start challengeLabel every bill as settled, void, past due, or current as of 15 March 2025.
Finance · 12 min
Case statements · Date functions
Start challengeFind visits that have started and do not have an end date.
Healthcare · 7 min
WHERE · NULL handling
Start challengeFind customers who never had a paid or shipped order.
E-commerce · 12 min
JOINs · WHERE
Start challengeList the people who sit in Engineering or Sales.
HR · 10 min
JOINs · WHERE
Start challengeFind product users with no rows in the event stream.
SaaS · 10 min
JOINs · NULL handling
Start challengeCount shipments in each operational status.
Logistics · 8 min
GROUP BY · SELECT
Start challengeMap each lead status onto the bucket sales uses.
Marketing · 8 min
Case statements · ORDER BY
Start challenge