How many cities have a regional population over 8000000?
SELECT count ( city )  FROM city WHERE regional_population  >  8000000
cities with a regional population over 8000000 refers to WHERE regional_population > 8000000; count cities refers to SELECT COUNT(city);