Table: global_challenge_results_2
Columns: overall_place
yacht_name
skipper
points
combined_elapsed_time

Question: What points has james allen as the skipper?
SQL: SELECT "points" FROM global_challenge_results_2 WHERE "skipper" = 'james allen'

Question: What is the name of the yacht where 12 is the overall place?
SQL: SELECT "yacht_name" FROM global_challenge_results_2 WHERE "overall_place" = '12'

Question: Which skipper has a combine elapsed time of 174d 01h 11m 59s?
SQL: SELECT "skipper" FROM global_challenge_results_2 WHERE "combined_elapsed_time" = '174d 01h 11m 59s'

Question: Which skipper has barclays adventurer as the name of the yacht?
SQL: SELECT "skipper" FROM global_challenge_results_2 WHERE "yacht_name" = 'barclays adventurer'

Question: What is the overall place that has 170d 11h 31m 10s as the combined elapsed time?
SQL: SELECT "overall_place" FROM global_challenge_results_2 WHERE "combined_elapsed_time" = '170d 11h 31m 10s'