Database: geo
Question: how many states have major rivers
SQL:
SELECT COUNT ( traverse ) FROM river WHERE LENGTH  >  750;