Database: geo
Question: how many states do not have rivers
SQL:
SELECT COUNT ( DISTINCT state_name ) FROM state WHERE state_name NOT IN ( SELECT traverse FROM river );