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.

Tables

`dbquacks_xmas.gps_tracking_events`

A table in a MotherDuck share; its columns are not listed here.

Database: https://dbquacks.com/data/databases/christmas_local.duckdb

This page as markdown: https://dbquacks.com/challenges/christmas/12.md

Play this challenge →