Table: football_teams
Columns: team
location
stadium
founded
joined
head_coach
captain

Question: Where is Bluetongue Stadium located? 
SQL: SELECT "location" FROM football_teams WHERE "stadium" = 'Bluetongue Stadium'

Question: When was the team, whose captain is Matt Smith,  founded? 
SQL: SELECT "founded" FROM football_teams WHERE "captain" = 'Matt Smith'

Question: Who's the captain of the team whose head coach is Alistair Edwards? 
SQL: SELECT "captain" FROM football_teams WHERE "head_coach" = 'Alistair Edwards'

Question: How many locations does the team Newcastle Jets come from? 
SQL: SELECT COUNT("location") FROM football_teams WHERE "team" = 'Newcastle Jets'

Question: Where is Westpac Stadium located? 
SQL: SELECT "location" FROM football_teams WHERE "stadium" = 'Westpac Stadium'