CREATE TABLE table_name_42 (wins INT, tournaments_played VARCHAR, year VARCHAR, best_finish VARCHAR)

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