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…
Keep campaigns that captured two or more lead rows.
Marketing · 10 min
JOINs · GROUP BY · HAVING
Start challengeCount orders placed in each calendar month.
E-commerce · 10 min
Date functions · GROUP BY
Start challengeFind bills whose payment date is later than the due date.
Finance · 10 min
JOINs · Date functions · Data cleaning
Start challengeFind diagnosis codes that appear on more than one encounter.
Healthcare · 8 min
GROUP BY · HAVING
Start challengeCount subscription rows in each status.
SaaS · 8 min
GROUP BY · SELECT
Start challengeSum posted expense debits by calendar month after cleaning the status text.
Finance · 14 min
JOINs · GROUP BY · Date functions · Data cleaning
Start challengeRank departments by the claim dollars payers have paid.
Healthcare · 16 min
Window Functions · JOINs · GROUP BY
Start challengeNumber paid and shipped orders in the order they were placed.
E-commerce · 14 min
Window Functions · WHERE
Start challengeRank every department that has employees by its headcount.
HR · 12 min
Window Functions · JOINs · GROUP BY
Start challenge