Database: geo
Question: what states border texas and have a major river
SQL:
SELECT state_name FROM border_info WHERE border  =  "texas" AND state_name IN ( SELECT traverse FROM river WHERE LENGTH  >  750 );