Courier workload in December

HardDoorDashleaddate mathcount distinctctes· 40 XP

December is DoorDash's busiest month. The courier experience team wants to see how hard couriers worked: how many deliveries, on how many days, and how much breathing room between pickups.

For each courier with a pickup in December 2025, show the number of deliveries, the number of different days they picked up orders, and the average minutes between consecutive pickups on the same day.

Expected output

  • avg_gap_minutes rounded to 1 decimal (empty if they never had two pickups on one day); any row order

Example of the shape (made-up values):

courier_id deliveries active_days avg_gap_minutes
12 34 21 95.3

Hints, the later steps and the answer come with Pro.

Write your query here. Ctrl + Enter submits.