Write a query to identify the top 5 hosts by revenue in a specific state on Turo.
For this exercise, use California as the requested state and include revenue from completed bookings only.
host_id, host_name, and total_revenue.total_revenue descending, then host_id ascending to break ties.| Column | Type | Description |
|---|---|---|
| host_idPK | INT | Unique host identifier |
| host_name | VARCHAR(100) | Host display name |
| state | VARCHAR(50) | Host's state |
| Column | Type | Description |
|---|---|---|
| booking_idPK | INT | Unique booking identifier |
| host_id | INT | Host associated with the booking |
| status | VARCHAR(20) | Booking status |
| revenue | NUMERIC(12,2) | Revenue generated by the booking |