Cold Case~62min

The SIM Swaps That Always Preceded a Roaming Spike

4 lines (LINE-101 through LINE-104) each had a SIM swap processed by the same retail agent, AGT-114, and within 90 minutes of every swap a burst of expensive roaming usage began in Nordholm — a country none of them had ever roamed in before — racking up $6,506.55 in wholesale charges. Each line was swapped back within 48 hours, before the billing cycle closed. LINE-205 also has $1,190.25 in Nordholm roaming, but its only SIM swap was 214 days earlier — a routine device upgrade, unrelated to the roaming.

Tables you'll query

linessim_swap_eventsroaming_sessions

What you'll learn

JOINsAggregations & GROUP BYDate & Time Functions
Investigate this case →