SQL Detective

Case 2: The Mango Basket

All cases

Green Park is a in Bengaluru. It has 30 and one big mango tree.

Today is Sunday. The Mango Party starts at 18:00.

In the morning, the gardener picked 50 mangoes. He put them in a basket in the .

At 16:00, the basket is empty.

The society keeps records in four tables. Find out who took the mangoes.

Chapter 1 of 10SELECT * FROM

Read the notice

Warm-up. SELECT * FROM a table shows all its rows and columns.

New to SQL? Case 1 teaches this from the start. You can also learn it here.

SELECT * FROM residents WHERE at_home = 'no';
Find
Everything in the notice.
Table
Show
all columns

Loading the SQL engine…