Cold Case~64min

The Jewelry Store Billed Like A Grocery Store

4 merchants (MER-101 through MER-104) are registered under MCC 5411 (Grocery Stores, 1.2% interchange), but their business license on file shows "Jewelry & Watches" (2.5% interchange) with no compliance exception approved — $2,795.00 in underpaid interchange across $215,000.00 of transaction volume. All 4 were onboarded by the same sales rep, REP-08. MER-022 also shows a registered MCC that does not exactly match its license category ("Grocery & Pharmacy Combo"), but that combo category has a documented, approved compliance exception keeping it at the grocery rate — not a misclassification.

Tables you'll query

merchantsbusiness_licensestransactions

What you'll learn

JOINsAggregations & GROUP BYSubqueries
Investigate this case →