Database: geo
Question: what states contain at least one major rivers
SQL:
SELECT traverse FROM river WHERE LENGTH  >  750;