Database: geo
Question: how many rivers do not traverse the state with the capital albany
SQL:
SELECT COUNT ( river_name ) FROM river WHERE traverse NOT IN ( SELECT state_name FROM state WHERE capital  =  "albany" );