11:42 PM. First Ledger Bank. Dr. Null is wiping the records.

Query Quest

Twelve companies. Twelve villains corrupting their data. Real Postgres in your browser, and one analyst who can write the query that stops them.

Chapter 1 · First Ledger Bank

Dr. Null

Wipes values from customer records. 5 cases stand in the way.

Daily Challenge--

Today's case

A fresh case every day - fewest tries tops the board.

Hall of Heroes · This week

Checking the board...

Full leaderboard →

Most Wanted

Five villains at large · each one falls to a single SQL technique

  • Dr. Null

    Wipes values from customer records.

    Defeated by COALESCE & WHERE IS NOT NULL

  • The Duplicator

    Floods orders with cloned rows.

    Defeated by GROUP BY + HAVING

  • Captain Cartesian

    Triggers runaway joins.

    Defeated by Proper JOIN conditions

  • The Injector

    Smuggles malicious input into unguarded queries.

    Defeated by Parameterized queries

  • Lord Lockout

    Seizes the database and holds transactions hostage.

    Defeated by Transaction control (COMMIT/ROLLBACK)

>_

ECHO LAB

Your AI sidekick writes fast SQL. Can you catch its bugs?

Debug 30 of ECHO's queries - wrong JOINs, sneaky NULLs, double counting - or ask it to explain your own SQL, line by line.

Enter the ECHO Lab →

HERO HANDBOOK

Every query type, ranked

Definitions, real examples and the Dialect Atlas.

Open the Handbook →