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