Case No. 001Assigned to YouDivision Data Integrity
The A&R Files

Halcyon Records has a data integrity problem. You're the analyst who solves it.

Open the file. Every clue is a query. Four investigations — streaming fraud, missing credits, chart manipulation, royalty theft — solved with real SQL, right in your browser.

FREE TO PLAY · NO INSTALL · RUNS ENTIRELY IN YOUR BROWSER
query_editor.sql
-- Case 001: streaming activity, Q3
SELECT track_id, artist, play_count
FROM streams
WHERE play_count > 1000000
AND unique_listeners < 500;
 
track_idartistflag
TRK-2291Midnight Runner⚠ anomaly
TRK-0847Coastline⚠ anomaly
The difference

This isn't another SQL course.

Tutorials teach you to write a query. They rarely give you a reason to care about the answer. This does.

The usual drill

  • Isolated exercises with no stakes
  • Correct syntax, no context for why it matters
  • Forgettable the moment the course ends
  • You practice SQL in a vacuum

The case file method

  • A real case, assigned by your boss
  • A wrong query means a wrong answer to a real question
  • Four investigations deep, one throughline
  • You use SQL to actually find something out
How it works

Four steps. One case at a time.

01

Get the case

Chief Reyes hands you an investigation — streaming fraud, missing credits, chart manipulation, or royalty theft.

02

Query the database

A real relational database, running in your browser. You write the actual SQL — nothing is simulated.

03

Find the answer

Hints are there if you're stuck, but the database only gives up the truth to the right query.

04

Close the case

Earn XP and a badge, then move to the next investigation — with a few loose threads that don't stay loose forever.

Meet the division

Your boss doesn't want a report. She wants an answer.

CR
Name
Chief Reyes
Role
Head, Data Integrity Division
Status
Watching your query history

You've just been hired as a Data Analyst at Halcyon Records. Chief Reyes doesn't hand out busywork — every case on your desk is a real problem the label needs solved: someone's numbers don't add up, and it's your job to find out why, with nothing but a database and a query editor.

"I don't need a dashboard. I need to know who did this, and I need it backed by a query I can defend in a room full of lawyers."
Inside the file

What it actually looks like.

Badge unlocked
✓
Case dialogue
CHIEF REYES
"Play counts don't lie. People do. Find out which one this is."
Progress
CASE 2 OF 4 · 620 XP
Who this is for

Built for people who'd rather investigate than drill.

Aspiring analystsCareer switchers into dataBI professionals sharpening real skillsAnyone who's bounced off a SQL course
HA

Built by a data strategy consultant who's spent years teaching SQL in live workshops — every case in this file is drawn from patterns real analysts actually get stuck on, not invented in a vacuum. Same architecture that powers Data Detective, the studio's first title.

Before you start

Frequently asked.

Is it actually free?

Yes. Episode One — all four cases — is free to play, no account required to start.

Do I need to already know SQL?

No. The cases are built to work for beginners through intermediate — the game gives you enough of the schema and hints to reason your way to the query.

Do I need to install anything?

No. It runs entirely in your browser using an in-browser database — no backend, no setup, nothing to download.

How long does it take?

Most players get through all four cases in about 45–90 minutes, depending on how much you lean on hints.

Case still open

Chief Reyes is waiting on your report.

Free to play, right now, in your browser. When you're done — or if you get stuck — I'd genuinely like to know.

Start the Investigation — Free
NO SPAM. ONE EMAIL WHEN EPISODE TWO OPENS.