Table: england_football_stadiums
Columns: stadium
capacity
club
division
rank_in_respective_divisions

Question: What division has a Rank in Respective Divisions of 5, and is the Altrincham club?
SQL: SELECT "division" FROM england_football_stadiums WHERE "rank_in_respective_divisions" = '5' AND "club" = 'altrincham'

Question: Which club has a capacity of 25138?
SQL: SELECT "club" FROM england_football_stadiums WHERE "capacity" = '25138'

Question: What Rank in Respective Divisions has a capacity of 4100?
SQL: SELECT "rank_in_respective_divisions" FROM england_football_stadiums WHERE "capacity" = '4100'

Question: What stadium has a club of west ham united?
SQL: SELECT "stadium" FROM england_football_stadiums WHERE "club" = 'west ham united'