Uber's supply team wants to know the most drivers online at any one moment on each day of the week of 2 March 2026, to plan incentives for the quiet days. Some shifts run past midnight.
For each calendar day, find the most drivers online at the same moment. When a shift ends at the exact moment another starts, count the end first.
Expected output
day as a date; sorted by dayExample of the shape (made-up values):
| day | peak_drivers |
|---|---|
| 2026-03-02 | 21 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.