Table: open_champ_stats
Columns: player
country
year_s_won
total
to_par

Question: Which Country has a To par smaller than 7, and a Total of 148?
SQL: SELECT "country" FROM open_champ_stats WHERE "to_par" < 7 AND "total" = 148

Question: Which player is from south africa?
SQL: SELECT "player" FROM open_champ_stats WHERE "country" = 'south africa'

Question: Which Year(s) won has a Total larger than 148, and a To par smaller than 17, and a Country of new zealand?
SQL: SELECT "year_s_won" FROM open_champ_stats WHERE "total" > 148 AND "to_par" < 17 AND "country" = 'new zealand'