SQL · DoorDash · Easy
You are given an orders table that records the lifecycle of every order placed on the platform. Each row carries an order_id, the timestamp when the order was created in created_at_utc, the timestamp when it was delivered in delivered_at_utc, and a status column describing its current state. Only rows whose status equals 'completed' are considered. Rows in any other state must be discarded and must not influence the result. Among the completed orders, an order is late when…
Checking your access…