Investigate the February dip

HardUbermissing dateswindow framesctesjoins· 120 XP (40 per step)

Uber's February dashboard shows a dip, and the head of operations wants to know which days were affected and how many trips were lost. Work it out in three steps. The calendar table has one row for every day from 1 January to 31 March 2026.

Step 1: Daily trips, with no missing days

Show the number of trip requests for every day of February 2026, including days with no requests (show 0).

Expected output

  • One row per day (28 rows), sorted by day

Example of the shape (made-up values):

day trips
2026-02-01 17
2026-02-02 0

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

Step 1 of 3

Write your query here. Ctrl + Enter submits.