Write a SQL query to find the top 10 cities based on average home price, including ties and ordering by city name as a tiebreaker.
Use the provided city and home listing data. Exclude cities without a non-null home price.
city_name and average_home_price.average_home_price descending, then city_name ascending.| Column | Type | Description |
|---|---|---|
| city_idPK | INT | Unique city identifier |
| city_name | VARCHAR(100) | City name |
| Column | Type | Description |
|---|---|---|
| home_idPK | INT | Unique home listing identifier |
| city_id | INT | References the city containing the home |
| home_price | DECIMAL(12,2) | Listing price of the home |