Table: golf_stats
Columns: year
tournaments_played
cuts_made
wins
top_10s
best_finish
earnings
scoring_average

Question: Tell me the highest wins for year less than 2000 and best finish of 4 and tournaments played less than 3
SQL: SELECT MAX("wins") FROM golf_stats WHERE "year" < 2000 AND "best_finish" = '4' AND "tournaments_played" < 3

Question: Tell me the scoring average for year less than 1998 and wins more than 3
SQL: SELECT "scoring_average" FROM golf_stats WHERE "year" < 1998 AND "wins" > 3