Tricky~21min

The Rate Drift

Finance sent a support ticket: 89 Growth-tier customers are disputing their invoices. They say they were promised ₹0.12/call but were billed ₹0.15. Sales has no record of promising the wrong rate. The pricing table shows ₹0.12. So where is ₹0.15 coming from?

Tables you'll query

pricing_versionssubscriptionsusage_billing

What you'll learn

SubqueriesJOINsAggregations & GROUP BY
Investigate this case →