Day-over-day change in March

MediumUberlagmissing datesjoins· 20 XP

Uber's operations team reviews each day of March against the day before it, to spot sudden drops.

For every day of March 2026, show the number of completed trips (0 if none) and the change from the previous day. For 1 March, compare with 28 February.

Expected output

  • Sorted by day; 31 rows

Example of the shape (made-up values):

day trips change_vs_prev_day
2026-03-01 15 -2

Hints, the later steps and the answer come with Pro.

Write your query here. Ctrl + Enter submits.