SQL Query Logic Lab

saved

Mission Briefing

Answer business questions about orders and customers by assembling SELECT, JOIN, WHERE, GROUP BY, and ORDER BY blocks.

Success Criteria

Complete scenario tasks and verify feedback.

Interactive Sandbox Guardrails

Schema BrowserER DiagramQuery Block BuilderJoin AnimationResult Grid

Deterministic browser simulation with server-authoritative scoring. Zero setup required.

Active Join TypeLEFT JOIN (Preserves All Customers)Devendra Rao (0 orders) retained

Result Row Count4 RowsAggregated output

Relational ConceptOuter Join Retention VerifiedDeterministic array simulation

1. Relational Query Block Assembler

SELECT BLOCKProjection & Aggregates

JOIN TYPE BLOCKRelationship Semantics

GROUP BY

ORDER BY

Compiled SQL Query (Display Only)

SELECT c.name, SUM(o.amount) AS total_spent
FROM customers c
LEFT JOIN orders o ON c.customer_id = o.customer_id
GROUP BY c.name
ORDER BY total_spent DESC;

Query Result Table (4 rows)

Customer Name	Total Spent
Bhavin Patel	₹8,900
Alice Sharma	₹6,700
Chitra Nair	₹4,600
Devendra RaoUnmatched	₹0

Submit Query Logic

Evaluates query structure, join semantics, and aggregate calculations against the 60/25/15 rubric.

SQL Query Logic Lab

1. Relational Query Block Assembler

Query Result Table (4 rows)

Indian Career Compass & Transition Blueprint

Your Starting Point