SQL Challenges · THE CHRISTMAS HEIST!
GPS Breadcrumb Trail Analysis
Difficulty: hard
Detective Quacker studies the package chain evidence. Packages were split and redistributed... someone inside handled the warehouse logistics, but who was making the actual deliveries? Scout Samantha arrives with temporal pattern analysis algorithms. Detective! Lets go back to Coach Waddles GPS data—hes still our delivery suspect! His GPS transponder created a breadcrumb trail of millions of location pings throughout December 2025. For each GPS ping, calculate how much time passed since the PRE…
Your task
Find the longest time gap in seconds between any two consecutive GPS pings from Coach Waddles (duck_id = 1) during December 2025. You will be working with `dbquacks_xmas.gps_tracking_events` (MotherDuck) table.