SQL Challenges · THE CHRISTMAS HEIST!
Telemetry Data Mining at Scale
Difficulty: hard
Detective Quackers jaw drops. The low-income district? But the thefts were from the wealthy district! Somethings not right here... Tech Specialist Bailey boots up his holographic data parser with excitement. Detective! Ive been analyzing those thousands of package tracking events Agent Smith found. Each one stores detailed sensor data in the event_metadata JSON column. Inside that structure, there are nested fields: temperature readings, scan quality metrics, handling notes, and more! We need t…
Your task
Find who loaded the most packages with temperature above 10°C and return their name. You will be working with `dbquacks_xmas.package_tracking_events` (MotherDuck) and `volunteer_ducks` (local) tables.