Database: geo
Question: what is the length of the longest river in the usa
SQL:
SELECT LENGTH FROM river WHERE LENGTH  =  ( SELECT MAX ( LENGTH ) FROM river );