Senior Code Review Mode

SQL Debugging Detective

Inspect buggy, broken queries written by junior engineers. Spot Cartesian joins, NULL traps, and syntax errors!

SOLVED CASES

0 / 3

AUTHOR: ALEX M. (JUNIOR INTERN)

Case #101: The Cartesian Join Explosion

Alex attempted to join users and orders using comma syntax but completely omitted the WHERE or ON join criteria! This created a Cartesian Cross Join, multiplying every user by every order in the database.

BUGGY SQL QUERY (DO NOT RUN AS IS):

-- Junior Dev Note: Trying to list customers and their order totals
SELECT u.name, o.total_amount 
FROM users u, orders o;

REPAIR THE SQL QUERY BELOW & EXECUTE:

SQL Query WorkspaceSQLite v3.45 (WASM Mode)

QUICK INSERT:

1