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