Database: geo
Question: how many major cities are there
SQL:
SELECT COUNT ( city_name ) FROM city WHERE population  >  150000;