Database: geo
Question: what are the populations of the states through which the mississippi river run
SQL:
SELECT population FROM state WHERE state_name IN ( SELECT traverse FROM river WHERE river_name  =  "mississippi" );