Database: geo
Question: what rivers are in states that border alabama
SQL:
SELECT river_name FROM river WHERE traverse IN ( SELECT border FROM border_info WHERE state_name  =  "alabama" );