Write a SQL query to find the top 10 cities based on average home price.
Use the provided cities and homes tables. Include only cities with at least one non-null home price.
city_name and average_home_price| Column | Type | Description |
|---|---|---|
| city_idPK | INT | Unique city identifier |
| city_name | VARCHAR(100) | City name |
| Column | Type | Description |
|---|---|---|
| home_idPK | INT | Unique home identifier |
| city_id | INT | City associated with the home |
| home_price | NUMERIC(12,2) | Listed home price in dollars |