Database: geo
Question: how long is the shortest river in the usa
SQL:
SELECT LENGTH FROM river WHERE LENGTH  =  ( SELECT MIN ( LENGTH ) FROM river );