Table: us_open_golf_stats
Columns: player
country
year_s_won
total
to_par
finish

Question: Year(s) won of 1994 , 1997 has what average total?
SQL: SELECT AVG("total") FROM us_open_golf_stats WHERE "year_s_won" = '1994 , 1997'

Question: Player of corey pavin, and a To par larger than 5 has what average total?
SQL: SELECT AVG("total") FROM us_open_golf_stats WHERE "player" = 'corey pavin' AND "to_par" > 5

Question: Total smaller than 285, and a To par larger than 1 belongs to what player?
SQL: SELECT "player" FROM us_open_golf_stats WHERE "total" < 285 AND "to_par" > 1

Question: Total larger than 285, and a Finish of t30 belongs to what player?
SQL: SELECT "player" FROM us_open_golf_stats WHERE "total" > 285 AND "finish" = 't30'