Database: geo
Question: what river is the longest one in the united states
SQL:
SELECT river_name FROM river WHERE LENGTH  =  ( SELECT MAX ( LENGTH ) FROM river );