Order Pickup Time SQL | Dataford Interview Questions

Your question is Order Pickup Time SQL. Start with the requirements and the three tables on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

DoorDash operations teams monitor how quickly confirmed orders are picked up by Dashers. Write a PostgreSQL query that calculates this interval by restaurant.

Requirements

Join the restaurant, order, and order log tables.
Include only completed orders with non-null timestamps where pickup occurred at or after restaurant confirmation.
Return each restaurant's valid order count and average confirmation-to-pickup time in minutes.
Include only restaurants with at least two valid orders, sorted by average time descending and restaurant name ascending as a tie-breaker.

Schema

restaurants

Column	Type	Description
restaurant_idPK	INT	Unique restaurant identifier
restaurant_name	VARCHAR(100)	Restaurant display name

orders

Column	Type	Description
order_idPK	INT	Unique DoorDash order identifier
restaurant_id	INT	Restaurant associated with the order
order_status	VARCHAR(20)	Current order lifecycle status

order_logs

Column	Type	Description
order_idPK	INT	Order associated with this log record
restaurant_confirmed_at	TIMESTAMP	Timestamp when the restaurant confirmed the order
dasher_picked_up_at	TIMESTAMP	Timestamp when the Dasher picked up the order