Database: geo
Question: how many states in the us does the shortest river run through
SQL:
SELECT COUNT ( DISTINCT traverse ) FROM river WHERE LENGTH  =  ( SELECT MIN ( DISTINCT LENGTH ) FROM river );