Table: yacht_race_2007_2
Columns: position
sail_number
yacht
state_country
yacht_type
loa_metres
skipper
corrected_time_d_hh_mm_ss

Question: Which Sail number has a Position smaller than 2?
SQL: SELECT "sail_number" FROM yacht_race_2007_2 WHERE "position" < 2

Question: WHICH Corrected time d:hh:mm:ss has a Position smaller than 7, and a Yacht type of cookson 50
SQL: SELECT "corrected_time_d_hh_mm_ss" FROM yacht_race_2007_2 WHERE "position" < 7 AND "yacht_type" = 'cookson 50'

Question: WHICH State/country that has ray roberts?
SQL: SELECT "state_country" FROM yacht_race_2007_2 WHERE "skipper" = 'ray roberts'

Question: WHICH Yacht type has a Corrected time 2:13:04:48?
SQL: SELECT "yacht_type" FROM yacht_race_2007_2 WHERE "corrected_time_d_hh_mm_ss" = '2:13:04:48'

Question: WHICH LOA (Metres) has a Corrected time d:hh:mm:ss of 3:12:07:43?
SQL: SELECT AVG("loa_metres") FROM yacht_race_2007_2 WHERE "corrected_time_d_hh_mm_ss" = '3:12:07:43'