Table: yacht_race_2007
Columns: position
race_number
sail_number
yacht
state_country
yacht_type
loa_metres
skipper
elapsed_time_d_hh_mm_ss

Question: How many different skippers of the yacht City Index Leopard?
SQL: SELECT COUNT("skipper") FROM yacht_race_2007 WHERE "yacht" = 'City Index Leopard'

Question: What are all elapsed time amounts for yacht type Reichel Pugh 55?
SQL: SELECT "elapsed_time_d_hh_mm_ss" FROM yacht_race_2007 WHERE "yacht_type" = 'Reichel Pugh 55'

Question: What are all elapsed time for yacht type STP 65?
SQL: SELECT "elapsed_time_d_hh_mm_ss" FROM yacht_race_2007 WHERE "yacht_type" = 'STP 65'

Question: If sail number is AUS 03, what are all associated race numbers?
SQL: SELECT "race_number" FROM yacht_race_2007 WHERE "sail_number" = 'AUS 03'

Question: What are all values of LOA(metres) for an elapsed time of 2:17:01:05?
SQL: SELECT "loa_metres" FROM yacht_race_2007 WHERE "elapsed_time_d_hh_mm_ss" = '2:17:01:05'

Question: When the elapsed time is 2:14:12:49, what are all yachts associated with this value?
SQL: SELECT "yacht" FROM yacht_race_2007 WHERE "elapsed_time_d_hh_mm_ss" = '2:14:12:49'