Database: world_1
Question: How many cities in each district have a population that is above the average population across all cities?
SQL:
SELECT count(*) ,  District FROM city WHERE Population  >  (SELECT avg(Population) FROM city) GROUP BY District