Dasher Waiting Time Query

DoorDash operations wants to measure how long each Dasher spent in the waiting_for_order status during a reporting period. Status logs represent status changes, so each row remains active until the next status event for that Dasher.

Write a PostgreSQL query for the period from 2025-02-01 00:00:00 through 2025-02-02 12:00:00.

Requirements

1. Use a window function to determine when each status interval ends.
2. Count only time during waiting_for_order, clipping intervals to the reporting boundaries.
3. Include every Dasher represented in the logs, including those with zero waiting time.
4. Return total waiting time in seconds, ordered by dasher_id.
5. Treat an open-ended final status as continuing through the report end, and ignore logs that do not overlap the reporting period.