Write a SQL query to identify the top-performing Hertz locations by revenue and rental volume over the last 30 days. Return the three highest-performing locations based on revenue, using rental volume and location name to break ties.
performance_rank, location_id, location_name, total_revenue, and rental_volumeperformance_rank ascending| Column | Type | Description |
|---|---|---|
| location_idPK | INTEGER | Unique Hertz rental location identifier |
| location_code | VARCHAR(20) | Short Hertz location code |
| location_name | VARCHAR(100) | Display name of the Hertz location |
| city | VARCHAR(80) | City where the location operates |
| Column | Type | Description |
|---|---|---|
| rental_idPK | INTEGER | Unique rental transaction identifier |
| location_id | INTEGER | Hertz location associated with the rental |
| rental_date | DATE | Date the rental was recorded |
| revenue | NUMERIC(12,2) | Revenue attributed to the rental |
| rental_status | VARCHAR(20) | Rental lifecycle status |