Table: pga_tour_stats_16
Columns: rank
player
country
earnings
events
wins

Question: Name the most rank for the United States with wins less than 1
SQL: SELECT MAX("rank") FROM pga_tour_stats_16 WHERE "country" = 'united states' AND "wins" < 1

Question: Name the most rank for wins more than 0 and events of 26
SQL: SELECT MAX("rank") FROM pga_tour_stats_16 WHERE "events" = 26 AND "wins" > 0

Question: Name the average earnings for rank of 3 and wins less than 3
SQL: SELECT AVG("earnings") FROM pga_tour_stats_16 WHERE "rank" = 3 AND "wins" < 3