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