Cold Case~60min
The Shadow Discount
~₹19.5 lakh in manual order discounts applied over 3 months. All between 9pm and 11pm. All by the same operator account. All to 23 specific customer accounts. Find the full picture.
Tables you'll query
ordersorder_adjustmentsemployeescustomers
What you'll learn
Window FunctionsCTEs (WITH clause)JOINsAggregations & GROUP BYDate & Time Functions