SQL Detective

Case 5: The Sweet Box Mystery

All cases

Laxmi Sweets is a busy sweet shop in Jaipur.

On 22 November, the Chauhan family had a wedding.

They ordered 40 boxes of . Only 25 boxes came.

The owner checks his records. Other orders were too.

Someone is taking boxes. Is it a driver? Find out.

Chapter 1 of 11SELECT * FROM

Read the complaint

Warm-up. Read the complaint first.

In this case, numbers matter. Watch for totals that hide the real story.

SELECT * FROM staff WHERE role = 'driver';
Find
Everything in the complaint.
Table
Show
all columns

Loading the SQL engine…