Database: geo
Question: which rivers run through states that border the state with the capital atlanta
SQL:
SELECT river_name FROM river WHERE traverse IN ( SELECT border FROM border_info WHERE state_name IN ( SELECT state_name FROM state WHERE capital  =  "atlanta" ) );