Table: pga_tour_stats_4
Columns: rank
player
country
earnings
events
wins

Question: What is the average earnings of the player from the United States with a win smaller than 2 and a rank larger than 3?
SQL: SELECT AVG("earnings") FROM pga_tour_stats_4 WHERE "country" = 'united states' AND "wins" < 2 AND "rank" > 3

Question: What is the average events that Al Geiberger played with wins smaller than 1?
SQL: SELECT AVG("events") FROM pga_tour_stats_4 WHERE "player" = 'al geiberger' AND "wins" < 1

Question: What is the rank where the events is 31?
SQL: SELECT "rank" FROM pga_tour_stats_4 WHERE "events" = 31

Question: What is the average events where the rank is smaller than 2 and wins are smaller than 5?
SQL: SELECT AVG("events") FROM pga_tour_stats_4 WHERE "rank" < 2 AND "wins" < 5