SELECT count(*) ,  District FROM city WHERE Population  >  (SELECT avg(Population) FROM city) GROUP BY District
How many cities in each district have a population that is above the average population across all cities?
SELECT count ( * ) , District FROM city WHERE Population > ( SELECT avg ( Population ) FROM city ) GROUP BY District
select count ( * ) , district from city where population > ( select avg ( population ) from city ) group by district
How many cities in each district have a population that is above the average population across all cities ?