How many cities have a population over 500,000?
SELECT count ( * )   FROM district where city_population > 500000
number of cities with a population over 500,000 refers to COUNT(*) WHERE city_population > 500000;