Table: footy_field
Columns: stadium
location
opened
built_for
capacity_at_construction

Question: Which stadium is located in Adelaide, South Australia? 
SQL: SELECT "stadium" FROM footy_field WHERE "location" = 'Adelaide, South Australia'

Question: In what location was a stadium built for the St Kilda Football Club?
SQL: SELECT "location" FROM footy_field WHERE "built_for" = 'St Kilda Football Club'

Question: What is the location of the Moorabbin Oval stadium?
SQL: SELECT "location" FROM footy_field WHERE "stadium" = 'Moorabbin Oval'

Question: What was the stadium in Adelaide, South Australia built for? 
SQL: SELECT "built_for" FROM footy_field WHERE "location" = 'Adelaide, South Australia'

Question: What was the stadium in Moorabbin, Victoria built for?
SQL: SELECT "built_for" FROM footy_field WHERE "location" = 'Moorabbin, Victoria'

Question: What was the capacity at construction of the stadium in Gold Coast, Queensland? 
SQL: SELECT "capacity_at_construction" FROM footy_field WHERE "location" = 'Gold Coast, Queensland'