Table: pga_championship_1990
Columns: player
country
year_s_won
total
to_par
finish

Question: What is the total sum of the player from the United States who won in 1986?
SQL: SELECT SUM("total") FROM pga_championship_1990 WHERE "country" = 'united states' AND "year_s_won" = '1986'

Question: What year did the player with a total less than 300 and a to par of 9 have a win?
SQL: SELECT "year_s_won" FROM pga_championship_1990 WHERE "total" < 300 AND "to_par" = 9

Question: What is total number of the to par of player john mahaffey, who has a total less than 298?
SQL: SELECT COUNT("to_par") FROM pga_championship_1990 WHERE "player" = 'john mahaffey' AND "total" < 298

Question: What is the sum of the total of the player who won in 1979?
SQL: SELECT SUM("total") FROM pga_championship_1990 WHERE "year_s_won" = '1979'

Question: What is the country of the player who has a total larger than 300?
SQL: SELECT "country" FROM pga_championship_1990 WHERE "total" > 300