Table: canadian_open_tennis
Columns: rank
country
wins
winners
first_title
last_title

Question: Which Wins has a Country of new zealand and a Last title larger than 1968?
SQL: SELECT MIN("wins") FROM canadian_open_tennis WHERE "country" = 'new zealand' AND "last_title" > 1968

Question: What is the total of Last title that has Wins smaller than 71 and a First title larger than 1968 and a Country of fiji?
SQL: SELECT COUNT("last_title") FROM canadian_open_tennis WHERE "wins" < 71 AND "first_title" > 1968 AND "country" = 'fiji'

Question: Which First title has Wins smaller than 8 and in Canada?
SQL: SELECT COUNT("first_title") FROM canadian_open_tennis WHERE "wins" < 8 AND "country" = 'canada'

Question: How many Winners have Wins of 1 and a Country of fiji and a First title smaller than 2004?
SQL: SELECT AVG("winners") FROM canadian_open_tennis WHERE "wins" = 1 AND "country" = 'fiji' AND "first_title" < 2004