Table: pga_championship_2004_players
Columns: player
country
year_won
total
to_par

Question: What is the Year won for the player with a larger than 4 To par and less the 157 Total?
SQL: SELECT "year_won" FROM pga_championship_2004_players WHERE "to_par" > 4 AND "total" < 157

Question: What is the Total for the Player who won after 1983 with less than 4 To par?
SQL: SELECT AVG("total") FROM pga_championship_2004_players WHERE "to_par" < 4 AND "year_won" > 1983

Question: What is the Total of the player who won before 1983 with a smaller than 4 To par?
SQL: SELECT COUNT("total") FROM pga_championship_2004_players WHERE "to_par" < 4 AND "year_won" < 1983