Lazada — Seller Late-Shipment Audit

Lazada's marketplace ops team wants a late-shipment audit across sellers. You have one table of orders with a promised ship date and an actual one (some orders haven't shipped yet at all). Four sequential steps: flag late orders, roll them up into each seller's late rate, rank sellers with a window function, then name the worst offenders with real volume behind them.