Tricky~21min

The Carrier Tax

Finance noticed shipping fees collected in Oct are ₹1.68L higher than the shipping rules should allow. The rules were updated in September. No one can explain the gap. Look at which orders were charged and when.

Tables you'll query

shipping_rulesorders

What you'll learn

SubqueriesJOINsAggregations & GROUP BY
Investigate this case →