Table: pga_championship_stats_8
Columns: player
country
year_s_won
total
to_par

Question: What is the average total for Dave Stockton?
SQL: SELECT AVG("total") FROM pga_championship_stats_8 WHERE "player" = 'dave stockton'

Question: What is the sum of the to par for the United States in the winning year of 1967, and has a total of more than 146?
SQL: SELECT SUM("to_par") FROM pga_championship_stats_8 WHERE "country" = 'united states' AND "year_s_won" = '1967' AND "total" > 146