SELECT count(*) ,  District FROM city WHERE Population  >  (SELECT avg(Population) FROM city) GROUP BY District
Find the number of cities in each district whose population is greater than the average population of 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
Find the number of cities in each district whose population is greater than the average population of cities ?