Table: pga_tournament
Columns: year
venue
winner
country
score

Question: What was the sum of the scores before the year 2002, that had the venue of Halmstad?
SQL: SELECT SUM("score") FROM pga_tournament WHERE "venue" = 'halmstad' AND "year" < 2002

Question: What was France's highest score when the venue was Bokskogens?
SQL: SELECT MAX("score") FROM pga_tournament WHERE "country" = 'france' AND "venue" = 'bokskogens'

Question: What was the earliest year during which the winner was Matthew King, and during which the score was higher than 270?
SQL: SELECT MIN("year") FROM pga_tournament WHERE "winner" = 'matthew king' AND "score" > 270

Question: What was the average year during which the score was 270?
SQL: SELECT AVG("year") FROM pga_tournament WHERE "score" = 270

Question: What were the total number scores after 2005, when the winner was David Patrick?
SQL: SELECT COUNT("score") FROM pga_tournament WHERE "winner" = 'david patrick' AND "year" > 2005

Question: What was the average year that the venue was Bokskogens?
SQL: SELECT AVG("year") FROM pga_tournament WHERE "venue" = 'bokskogens'