Database: world_1
Question: 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