Database: geo
Question: through which states does the longest river in texas run
SQL:
SELECT traverse FROM river WHERE LENGTH  =  ( SELECT MAX ( LENGTH ) FROM river WHERE traverse  =  "texas" );