Table: senior_pga_tour_stats
Columns: rank
player
country
earnings
wins

Question: On average, how many wins have a rank lower than 1?
SQL: SELECT AVG("wins") FROM senior_pga_tour_stats WHERE "rank" < 1

Question: What is the lowest level of Earnings($) to have a Wins value of 22 and a Rank lower than 2?
SQL: SELECT MIN("earnings") FROM senior_pga_tour_stats WHERE "wins" = 22 AND "rank" < 2

Question: In total, how much did the United States player George Archer earn with Wins lower than 24 and a rank that was higher than 5?
SQL: SELECT COUNT("earnings") FROM senior_pga_tour_stats WHERE "country" = 'united states' AND "wins" < 24 AND "player" = 'george archer' AND "rank" > 5