Interview Guides
You are given shipment planning and receipt data from Lucid Motors supplier operations. Write a SQL query to identify which suppliers most frequently miss their delivery windows for shipments scheduled in March 2024. A shipment counts as missed if the actual arrival timestamp is before the scheduled window start, after the scheduled window end, or missing entirely because nothing was received. Return each supplier's total scheduled shipments, number of missed shipments, and missed-window rate, ordered from worst to best.
