Database: geo
Question: what are the major cities in states through which the mississippi runs
SQL:
SELECT city_name FROM city WHERE population  >  150000 AND state_name IN ( SELECT traverse FROM river WHERE LENGTH  >  750 AND river_name  =  "mississippi" );