Routine~11min
The Pallet Marked Delivered Twice
Ops flagged inflated delivery counts on Route 03. Turns out 5 pallets have two separate "delivered" scans logged seconds apart — a handheld scanner glitch double-fired when the signal dropped mid-scan. Don't confuse this with pallets that have a delivered scan AND a later returned scan — that's a real return, not a duplicate.
Tables you'll query
palletsscan_events
What you'll learn
Aggregations & GROUP BY