Table: volvo_ocean_race_teams
Columns: team_boat_name
sail_no
flag
design_firm
builder
skipper

Question: Which flag was on the Green Marine's boat?
SQL: SELECT "flag" FROM volvo_ocean_race_teams WHERE "builder" = 'Green Marine'

Question: Who build the boat where Ken Read was the skipper?
SQL: SELECT "builder" FROM volvo_ocean_race_teams WHERE "skipper" = 'Ken Read'

Question: Farr Yacht Design designed boats for how many country/flags?
SQL: SELECT COUNT("flag") FROM volvo_ocean_race_teams WHERE "design_firm" = 'Farr Yacht Design'

Question: Who were the builders of the boat designed by Botin Carkeek?
SQL: SELECT "builder" FROM volvo_ocean_race_teams WHERE "design_firm" = 'Botin Carkeek'