Table: friends_life_teams
Columns: team
location
county
division
home_ground
coach
captain

Question: Who is the coach of the team in Leicester? 
SQL: SELECT "coach" FROM friends_life_teams WHERE "location" = 'Leicester'

Question: What is the name of the team from Derbyshire county? 
SQL: SELECT "team" FROM friends_life_teams WHERE "county" = 'Derbyshire'

Question: Who is the captain of the Gloucestershire Gladiators? 
SQL: SELECT "captain" FROM friends_life_teams WHERE "team" = 'Gloucestershire Gladiators'

Question: Who is the captain of the team in Southampton? 
SQL: SELECT "captain" FROM friends_life_teams WHERE "location" = 'Southampton'

Question: Where is the team in Sussex county located? 
SQL: SELECT "location" FROM friends_life_teams WHERE "county" = 'Sussex'

Question: Who is the captain of the team in Essex county? 
SQL: SELECT "captain" FROM friends_life_teams WHERE "county" = 'Essex'