Tricky~22min

The Discount Splitter

VOL12 wholesale discount payouts have been climbing steadily, but the order pattern behind them looks off — a cluster of same-day orders from the same customers that never quite reach a round wholesale number. Figure out what's driving it.

Tables you'll query

customersdiscount_rulesorders

What you'll learn

SubqueriesJOINsAggregations & GROUP BY
Investigate this case →