Cold Case~57min
The Container That Was Never on the Ship
5 containers are marked departed with zero gate scans on record — never physically scanned into the port at all. All 5 were filed by the same agent, AGENT-07. 8 more "departed" containers also look suspicious — their gate scan happened several hours after the manifest cutoff — but a scan did happen, just delayed by normal processing backlog.
Tables you'll query
containersmanifestsgate_scans
What you'll learn
JOINsSubqueriesDate & Time Functions