Drivers delayed 3+ days in a row
Ops wants to flag a reliability risk: drivers who were marked 'Delayed' for 3 or more consecutive days.
Return the driver name for each driver who hit a streak like this. Each qualifying driver should appear only once, even if they have more than one such streak.
Schema
▸driver_checkins
| id | INT |
| driver | TEXT |
| checkin_date | DATE |
| status | TEXT |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
The reference solution and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime