CREATE TABLE city (District VARCHAR(255), Population INTEGER)
Find the number of cities in each district whose population is greater than the average population of cities?
    
SQL: SELECT COUNT(*), District FROM city WHERE Population > (SELECT AVG(Population) FROM city) GROUP BY District