Database: geo
Question: which is the shortest river
SQL:
SELECT river_name FROM river WHERE LENGTH  =  ( SELECT MIN ( LENGTH ) FROM river );