Uber's fleet team wants to know which vehicle types bring in the most money.
For completed trips, show each driver vehicle_type with its number of trips and total fare.
Expected output
Example of the shape (made-up values):
| vehicle_type | trips | revenue |
|---|---|---|
| Comfort | 260 | 6900.40 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.