Skip to content

2987. Find Expensive Cities

1
2
3
4
5
SELECT city
FROM Listings
GROUP BY 1
HAVING AVG(price) > (SELECT AVG(price) FROM Listings)
ORDER BY 1;