Database: geo
Question: what are the states through which the longest river runs
SQL:
SELECT traverse FROM river WHERE LENGTH  =  ( SELECT MAX ( LENGTH ) FROM river );