SQL Detective

Case 4: The Tech Fair Drone

All cases

Hyderabad. The City Tech Fair. 60 teams show their ideas.

Team Garuda built a small delivery . Today it won first prize.

At lunch, from 13:00 to 14:00, the team left the .

At 14:00, the is gone. Only its empty box is there.

The fair has records. But volunteers typed them by hand, and they are messy.

Chapter 1 of 10SELECT * FROM

Read the report

Warm-up. Read the report first.

This case is about messy text. Look at the visitors table too. Tap it in the Tables panel.

SELECT * FROM visitors WHERE company = 'Nova Drones';
Find
Everything in the report.
Table
Show
all columns

Loading the SQL engine…