Table: medal_counts_2011_pacific
Columns: rank
gold
silver
bronze
total

Question: What is the sum of Gold, when Silver is greater than 6, when Rank is 1, and when Bronze is less than 61?
SQL: SELECT SUM("gold") FROM medal_counts_2011_pacific WHERE "silver" > 6 AND "rank" = '1' AND "bronze" < 61

Question: What is the lowest Silver, when Bronze is 1, and when Total is less than 3?
SQL: SELECT MIN("silver") FROM medal_counts_2011_pacific WHERE "bronze" = 1 AND "total" < 3

Question: What is the average Gold, when Silver is less than 107, when Bronze is greater than 42, and when Rank is 3?
SQL: SELECT AVG("gold") FROM medal_counts_2011_pacific WHERE "silver" < 107 AND "bronze" > 42 AND "rank" = '3'