Table: bbl_2007_08_teams
Columns: team
city_area
arena
capacity
last_season

Question: What is the capacity for the arena in Chester?
SQL: SELECT "capacity" FROM bbl_2007_08_teams WHERE "city_area" = 'chester'

Question: Which arena has a capactiy of 1,100?
SQL: SELECT "arena" FROM bbl_2007_08_teams WHERE "capacity" = '1,100'

Question: What is the last season that the Scottish Rocks played?
SQL: SELECT "last_season" FROM bbl_2007_08_teams WHERE "team" = 'scottish rocks'

Question: Which arena has the Milton Keynes Lions and a capacity of 800?
SQL: SELECT "arena" FROM bbl_2007_08_teams WHERE "capacity" = '800' AND "team" = 'milton keynes lions'

Question: What is the last season the Worcester Wolves played?
SQL: SELECT "last_season" FROM bbl_2007_08_teams WHERE "team" = 'worcester wolves'

Question: Which team is from Birmingham & Telford?
SQL: SELECT "team" FROM bbl_2007_08_teams WHERE "city_area" = 'birmingham & telford'