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