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
Investigate this case →