Uber's pricing team wants a quick check: do riders pay more per trip at the weekend?
For completed trips, compare weekends (Saturday and Sunday) with weekdays: show the number of trips and the average fare.
Expected output
day_type is 'weekend' or 'weekday'; avg_fare rounded to 2 decimalsExample of the shape (made-up values):
| day_type | trips | avg_fare |
|---|---|---|
| weekend | 380 | 19.75 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.