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