Cold Case~58min
The Franchise Royalty That Was Underreported
6 franchise locations under-report sales versus the POS system's own totals, but only on Saturdays and Sundays — weekdays match almost exactly. Weekends are when those locations switch to a manual end-of-day tally instead of the automatic POS export. LOC-014 also shows a mismatch on one Tuesday, but that date has a documented POS outage — a real system gap, not underreporting.
Tables you'll query
locationsself_reported_salespos_salespos_outage_incidents
What you'll learn
JOINsDate & Time FunctionsAggregations & GROUP BY