Database: geo
Question: which state has the longest river
SQL:
SELECT traverse FROM river WHERE LENGTH  =  ( SELECT MAX ( LENGTH ) FROM river );