SQL Lab
SQL Fundamentals: Read This First
Nine short reading pages - filtering, joins, aggregates, subqueries and window functions - each linked from the cases that need it.
Or read the history behind it
The Database Chronicles - How relational query languages revolutionized software.
THE BLACK FRIDAY
Complete all challenges during Black Friday and unlock an exclusive 50% discount on any ScaleDojo plan. Don't miss out!
Compare stats and compete with top...
CHALLENGE MAP
Progressive SQL Mystery Curriculum
Solve levels sequentially - each clear unlocks the next challenge
Act 1
#1 The Vanishing CTO
EasyFresherSELECT โข WHERE
#2 Last Seen
EasyFresherORDER BY โข LIMIT
#3 Who Else Was There
EasyFresherDISTINCT
#4 The Security Lead
EasyFresherAND โข Combining Conditions
#5 After Dark
EasyFresherComparison Operators
#6 The Unsigned Visitor
EasyFresherIS NULL
#7 Inside Access
EasyFresherIN
#8 The Critical Window
EasyFresherBETWEEN
#9 The Money Men
EasyFresherLIKE โข Wildcards
#10 No Exit
EasyFresherORDER BY โข Reading Timelines
Act 2
#11 Follow the Money
Easy-MediumSDE 1COUNT
#12 The Big Number
Easy-MediumSDE 1MAX
#13 Bleeding Out
Easy-MediumSDE 1SUM
#14 The Baseline
Easy-MediumSDE 1AVG
#15 Vendor Roll Call
Easy-MediumSDE 1StripeGROUP BY โข COUNT
#16 The Heavy Hitters
Easy-MediumSDE 1StripePayPalGROUP BY โข HAVING โข SUM
#17 Midnight Money
Easy-MediumSDE 1StripeDate & Time Functions
#18 The Doctored Invoice
Easy-MediumSDE 1PayPalComparing Columns
#19 The Spike
Easy-MediumSDE 1StripeGROUP BY โข strftime
#20 The Discretionary Drain
Easy-MediumSDE 1DISTINCT โข WHERE
Act 3
#21 Names, Not Numbers
MediumSDE 2INNER JOIN
#22 The Whistleblower
MediumSDE 2JOIN โข LIKE
#23 Come Alone
MediumSDE 2Self-referencing JOINs โข Table Aliases
#24 The Ghost
MediumSDE 2LEFT JOIN โข IS NULL
#25 Damage Control
MediumSDE 2JOIN
#26 Knock Knock
MediumSDE 2JOIN โข Filtering
#27 The Source Account
MediumSDE 2JOIN
#28 The Empty Chairs
MediumSDE 2LEFT JOIN โข IS NULL
#29 Sessions Left Open
MediumSDE 2JOIN โข IS NULL
#30 The Cleanup Crew
MediumSDE 2Multiple JOINs โข LIKE
Act 4
#31 Above the Waterline
Medium-HardSDE 2Scalar Subquery
#32 Shells on the Books
Medium-HardSDE 2PayPalIN Subquery
#33 The Common Thread
Medium-HardSDE 2PayPalGROUP BY โข HAVING โข COUNT
#34 Not on the List
Medium-HardSDE 2StripeEXCEPT
#35 All the Outflows
Medium-HardSDE 2UNION
#36 The Whale
HardSDE 3Subquery with MAX
#37 The Funnel
HardSDE 3CTE (WITH)
#38 Two Levels Down
HardSDE 3Nested Subqueries
#39 Built to Vanish
HardSDE 3Date Arithmetic โข julianday
#40 The Alias
HardSDE 3CTE (WITH) โข IN Subquery
Act 5
#41 The Million Mark
HardSDE 3AmazonNetflixWindow Functions โข SUM OVER
#42 Top of Each Stack
HardSDE 3AmazonUberROW_NUMBER โข PARTITION BY
#43 The Hole in the Patrol
HardSDE 3UberDoorDashLAG โข Window Ordering
#44 The Lion's Share
HardStaff+AmazonNetflixWindow over Aggregate โข Percent of Total
#45 Against Their Own Average
HardSDE 3Correlated Subquery
#46 First Contact
ExpertSDE 3MetaLinkedInMIN OVER โข PARTITION BY
#47 The Alibi Cracks
ExpertSDE 3Filtering โข Timestamps โข Synthesis
#48 Follow the Rank
ExpertStaff+AmazonNetflixUberRANK โข Window over GROUP BY
#49 The Last Message
ExpertSDE 3MAX โข Synthesis
#50 Name the Mastermind
LegendaryStaff+AmazonGoogleCTE Chains โข Synthesis โข The Whole Toolbox
Act 6
#51 Generations
EasySDE 1AirbnbLinkedInCASE โข Bucketing โข GROUP BY
#52 Three Counters at Once
MediumSDE 2AmazonMetaCASE โข COUNT โข GROUP BY
#53 Unknown Is Not Zero
MediumSDE 2AirbnbUberCOALESCE โข NULLIF โข LEFT JOIN
#54 Share of the Whole
MediumSDE 2GoogleStripePercent of Total โข Subquery โข ROUND
#55 Months in Columns
MediumSDE 2AmazonStripeCASE โข Conditional Aggregation โข Pivot
Act 7
#56 Never Ordered
MediumSDE 2AirbnbUberAnti-Join โข NOT EXISTS โข LEFT JOIN
#57 The Org Chart
MediumSDE 2MicrosoftLinkedInSelf Join โข LEFT JOIN
#58 New in the Second Quarter
MediumSDE 2GoogleLinkedInEXCEPT โข INTERSECT โข Set Operations
#59 Electronics Fans
MediumSDE 2AmazonMetaEXISTS โข Correlated Subquery
#60 Above Their Own Category Average
HardSDE 3AmazonGoogleCorrelated Subquery โข AVG
Act 8
#61 The Second Price Tier
MediumSDE 2AmazonMetaDENSE_RANK โข PARTITION BY
#62 Latest Order, Beside Every Order
HardSDE 3AmazonAirbnbFIRST_VALUE โข PARTITION BY โข Window Ordering
#63 Days Between Orders
HardSDE 3AmazonUberLAG โข PARTITION BY โข julianday
#64 Spend Quartiles
HardSDE 3GoogleStripeNTILE โข CTE โข Ranking
#65 The Three-Order Average
HardSDE 3GoogleNetflixWindow Frame โข ROWS BETWEEN โข AVG OVER
Act 9
#66 Signed Up, Then Came Back
HardSDE 3GoogleAirbnbCohorts โข EXISTS โข Date Arithmetic
#67 Where Shoppers Drop Off
HardSDE 3AmazonMetaFunnel โข COUNT DISTINCT โข Subquery
#68 Every Day, Even the Quiet Ones
HardSDE 3AmazonStripeRecursive CTE โข Date Spine โข LEFT JOIN
#69 The Longest Streak
HardSDE 3GoogleAmazonGaps and Islands โข ROW_NUMBER โข Date Arithmetic
#70 How Many Visits?
HardSDE 3GoogleMetaSessionization โข LAG โข Window Functions
Act 10
#71 Fourth-Highest Salary
MediumSDE 2AmazonGoogleMicrosoftDISTINCT โข LIMIT OFFSET โข DENSE_RANK
#72 Keep Only the Latest
MediumSDE 2AirbnbStripeLinkedInROW_NUMBER โข Deduplication โข Latest Row Per Group
#73 The Median Salary
HardSDE 3GoogleMetaMedian โข LIMIT OFFSET โข Subquery
#74 Top Three Pay Bands per Department
HardSDE 3AmazonGoogleMetaDENSE_RANK โข Top-N per Group โข Ties
#75 Bought A and B, but Not C
HardSDE 3AmazonAirbnbUberHAVING โข Conditional Aggregation โข Set Logic