The payments team at Uber wants to know where riders still pay with cash, to plan which cities keep the cash option.
For completed trips paid in cash, show each city's number of trips and the average fare. Only include cities with at least 15 completed cash trips.
Expected output
avg_fare rounded to 2 decimals; any row orderExample of the shape (made-up values):
| city | cash_trips | avg_fare |
|---|---|---|
| Lakeside | 21 | 18.40 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.