Table: pga_tour_stats_7
Columns: rank
player
country
earnings
wins

Question: Who has the lowest earnings that has a rank smaller than 2?
SQL: SELECT MIN("earnings") FROM pga_tour_stats_7 WHERE "rank" < 2

Question: What was the total number of wins with player Mike Hill with a rank bigger than 2?
SQL: SELECT COUNT("wins") FROM pga_tour_stats_7 WHERE "rank" > 2 AND "player" = 'mike hill'