SQL Lab
NEW TO SQL LAB?
STEP 1START HERE
ScaleDojo Learn: SQL Fundamentals
Learn SQL from zero to hero while solving the Vantage Systems breach data mystery.
2
Or read the history behind it
The Database Chronicles - How relational query languages revolutionized software.
LEADERBOARDLIVE
Compare stats and compete with top...
View
CHALLENGE MAP
Progressive SQL Mystery Curriculum
0/50
COMPLETED
2 of 10 levels unlocked·Start with Level 1 to begin your journey
Solve levels sequentially - each clear unlocks the next challenge
2/10
ACCESSIBLE
Architect Feature: Want to bypass sequential unlock? Go to your Profile and enable Architect's Sandbox.
Act 1
ACT PROGRESS0/10
1
#1 The Vanishing CTO
EasyFresher🔍 Vantage Systems Investigation
SELECT • WHERE
SELECT
WHERE
Standard Challenge
Start Level →
#2 Last Seen
EasyFresher🔍 Vantage Systems Investigation
ORDER BY • LIMIT
ORDER BY
LIMIT
Standard Challenge
Locked
#3 Who Else Was There
EasyFresher🔍 Vantage Systems Investigation
DISTINCT
DISTINCT
Standard Challenge
Locked
#4 The Security Lead
EasyFresher🔍 Vantage Systems Investigation
AND • Combining Conditions
AND
Combining Conditions
Standard Challenge
Locked
#5 After Dark
EasyFresher🔍 Vantage Systems Investigation
Comparison Operators
Comparison Operators
Standard Challenge
Locked
#6 The Unsigned Visitor
EasyFresher🔍 Vantage Systems Investigation
IS NULL
IS NULL
Standard Challenge
Locked
#7 Inside Access
EasyFresher🔍 Vantage Systems Investigation
IN
IN
Standard Challenge
Locked
#8 The Critical Window
EasyFresher🔍 Vantage Systems Investigation
BETWEEN
BETWEEN
Standard Challenge
Locked
#9 The Money Men
EasyFresher🔍 Vantage Systems Investigation
LIKE • Wildcards
LIKE
Wildcards
Standard Challenge
Locked
#10 No Exit
EasyFresher🔍 Vantage Systems Investigation
ORDER BY • Reading Timelines
ORDER BY
Reading Timelines
Standard Challenge
Locked
Act 2
ACT PROGRESS0/10
#11 Follow the Money
Easy-MediumSDE 1🔍 Vantage Systems Investigation
COUNT
COUNT
Standard Challenge
Locked
#12 The Big Number
Easy-MediumSDE 1🔍 Vantage Systems Investigation
MAX
MAX
Standard Challenge
Locked
#13 Bleeding Out
Easy-MediumSDE 1🔍 Vantage Systems Investigation
SUM
SUM
Standard Challenge
Locked
#14 The Baseline
Easy-MediumSDE 1🔍 Vantage Systems Investigation
AVG
AVG
Standard Challenge
Locked
#15 Vendor Roll Call
Easy-MediumSDE 1Stripe🔍 Vantage Systems Investigation
GROUP BY • COUNT
GROUP BY
COUNT
Standard Challenge
Locked
#16 The Heavy Hitters
Easy-MediumSDE 1StripePayPal🔍 Vantage Systems Investigation
GROUP BY • HAVING • SUM
GROUP BY
HAVING
SUM
Standard Challenge
Locked
#17 Midnight Money
Easy-MediumSDE 1Stripe🔍 Vantage Systems Investigation
Date & Time Functions
Date & Time Functions
Standard Challenge
Locked
#18 The Doctored Invoice
Easy-MediumSDE 1PayPal🔍 Vantage Systems Investigation
Comparing Columns
Comparing Columns
Standard Challenge
Locked
#19 The Spike
Easy-MediumSDE 1Stripe🔍 Vantage Systems Investigation
GROUP BY • strftime
GROUP BY
strftime
Standard Challenge
Locked
#20 The Discretionary Drain
Easy-MediumSDE 1🔍 Vantage Systems Investigation
DISTINCT • WHERE
DISTINCT
WHERE
Standard Challenge
Locked
Act 3
ACT PROGRESS0/10
#21 Names, Not Numbers
MediumSDE 2🔍 Vantage Systems Investigation
INNER JOIN
INNER JOIN
Standard Challenge
Locked
#22 The Whistleblower
MediumSDE 2🔍 Vantage Systems Investigation
JOIN • LIKE
JOIN
LIKE
Standard Challenge
Locked
#23 Come Alone
MediumSDE 2🔍 Vantage Systems Investigation
Self-referencing JOINs • Table Aliases
Self-referencing JOINs
Table Aliases
Standard Challenge
Locked
#24 The Ghost
MediumSDE 2🔍 Vantage Systems Investigation
LEFT JOIN • IS NULL
LEFT JOIN
IS NULL
Standard Challenge
Locked
#25 Damage Control
MediumSDE 2🔍 Vantage Systems Investigation
JOIN
JOIN
Standard Challenge
Locked
#26 Knock Knock
MediumSDE 2🔍 Vantage Systems Investigation
JOIN • Filtering
JOIN
Filtering
Standard Challenge
Locked
#27 The Source Account
MediumSDE 2🔍 Vantage Systems Investigation
JOIN
JOIN
Standard Challenge
Locked
#28 The Empty Chairs
MediumSDE 2🔍 Vantage Systems Investigation
LEFT JOIN • IS NULL
LEFT JOIN
IS NULL
Standard Challenge
Locked
#29 Sessions Left Open
MediumSDE 2🔍 Vantage Systems Investigation
JOIN • IS NULL
JOIN
IS NULL
Standard Challenge
Locked
#30 The Cleanup Crew
MediumSDE 2🔍 Vantage Systems Investigation
Multiple JOINs • LIKE
Multiple JOINs
LIKE
Standard Challenge
Locked
Act 4
ACT PROGRESS0/10
#31 Above the Waterline
Medium-HardSDE 2🔍 Vantage Systems Investigation
Scalar Subquery
Scalar Subquery
Standard Challenge
Locked
#32 Shells on the Books
Medium-HardSDE 2PayPal🔍 Vantage Systems Investigation
IN Subquery
IN Subquery
Standard Challenge
Locked
#33 The Common Thread
Medium-HardSDE 2PayPal🔍 Vantage Systems Investigation
GROUP BY • HAVING • COUNT
GROUP BY
HAVING
COUNT
Standard Challenge
Locked
#34 Not on the List
Medium-HardSDE 2Stripe🔍 Vantage Systems Investigation
EXCEPT
EXCEPT
Standard Challenge
Locked
#35 All the Outflows
Medium-HardSDE 2🔍 Vantage Systems Investigation
UNION
UNION
Standard Challenge
Locked
#36 The Whale
HardSDE 3🔍 Vantage Systems Investigation
Subquery with MAX
Subquery with MAX
Standard Challenge
Locked
#37 The Funnel
HardSDE 3🔍 Vantage Systems Investigation
CTE (WITH)
CTE (WITH)
Standard Challenge
Locked
#38 Two Levels Down
HardSDE 3🔍 Vantage Systems Investigation
Nested Subqueries
Nested Subqueries
Standard Challenge
Locked
#39 Built to Vanish
HardSDE 3🔍 Vantage Systems Investigation
Date Arithmetic • julianday
Date Arithmetic
julianday
Standard Challenge
Locked
#40 The Alias
HardSDE 3🔍 Vantage Systems Investigation
CTE (WITH) • IN Subquery
CTE (WITH)
IN Subquery
Standard Challenge
Locked
Act 5
ACT PROGRESS0/10
#41 The Million Mark
HardSDE 3AmazonNetflix🔍 Vantage Systems Investigation
Window Functions • SUM OVER
Window Functions
SUM OVER
Standard Challenge
Locked
#42 Top of Each Stack
HardSDE 3AmazonUber🔍 Vantage Systems Investigation
ROW_NUMBER • PARTITION BY
ROW_NUMBER
PARTITION BY
Standard Challenge
Locked
#43 The Hole in the Patrol
HardSDE 3UberDoorDash🔍 Vantage Systems Investigation
LAG • Window Ordering
LAG
Window Ordering
Standard Challenge
Locked
#44 The Lion's Share
HardStaff+AmazonNetflix🔍 Vantage Systems Investigation
Window over Aggregate • Percent of Total
Window over Aggregate
Percent of Total
Standard Challenge
Locked
#45 Against Their Own Average
HardSDE 3🔍 Vantage Systems Investigation
Correlated Subquery
Correlated Subquery
Standard Challenge
Locked
#46 First Contact
ExpertSDE 3MetaLinkedIn🔍 Vantage Systems Investigation
MIN OVER • PARTITION BY
MIN OVER
PARTITION BY
Standard Challenge
Locked
#47 The Alibi Cracks
ExpertSDE 3🔍 Vantage Systems Investigation
Filtering • Timestamps • Synthesis
Filtering
Timestamps
Synthesis
Standard Challenge
Locked
#48 Follow the Rank
ExpertStaff+AmazonNetflixUber🔍 Vantage Systems Investigation
RANK • Window over GROUP BY
RANK
Window over GROUP BY
Standard Challenge
Locked
#49 The Last Message
ExpertSDE 3🔍 Vantage Systems Investigation
MAX • Synthesis
MAX
Synthesis
Standard Challenge
Locked
#50 Name the Mastermind
LegendaryStaff+AmazonGoogle🔍 Vantage Systems Investigation
CTE Chains • Synthesis • The Whole Toolbox
CTE Chains
Synthesis
The Whole Toolbox
Standard Challenge
Locked