Uber's pricing team suspects some cities are mostly short hops. They want the trip-length mix per city in one table.
For completed trips, show per city how many were short (under 5 km), medium (5 to under 15 km) and long (15 km or more), as three columns.
Expected output
Example of the shape (made-up values):
| city | short_trips | medium_trips | long_trips |
|---|---|---|---|
| Lakeside | 120 | 80 | 15 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.