Table: pga_tour_stats_23
Columns: rank
player
country
earnings
events
wins

Question: Which Wins is the highest one that has a Country of united states, and a Player of andy bean, and a Rank smaller than 4?
SQL: SELECT MAX("wins") FROM pga_tour_stats_23 WHERE "country" = 'united states' AND "player" = 'andy bean' AND "rank" < 4

Question: Which Country has a Rank of 5?
SQL: SELECT "country" FROM pga_tour_stats_23 WHERE "rank" = 5

Question: Which Earnings ($) is the lowest one that has a Rank smaller than 1?
SQL: SELECT MIN("earnings") FROM pga_tour_stats_23 WHERE "rank" < 1