Listings Above City Average Price

Return listings priced above the average price of their city. Order by id.

Table schema

Listings(id INT PRIMARY KEY, city VARCHAR(10), agent VARCHAR(10), price INT, area_sqft INT, listed_on DATE, sold_on DATE)

Sample data

id | city | agent | price | area_sqft | listed_on | sold_on
1 | Pune | Ria | 300000 | 1000 | 2026-01-01 | 2026-02-01
2 | Pune | Sam | 450000 | 1500 | 2026-01-10 | NULL
3 | Delhi | Ria | 800000 | 2000 | 2026-02-01 | 2026-03-15
4 | Delhi | Tej | 600000 | 1000 | 2026-02-10 | 2026-02-20
5 | Pune | Ria | 150000 | 500 | 2026-03-01 | 2026-03-11