Table: lpga_players_2
Columns: rank
player
country
earned
earnings

Question: What earned has 5 for the rank?
SQL: SELECT "earned" FROM lpga_players_2 WHERE "rank" = 5

Question: What is the average earnings ($) that has meg mallon as the player, with a rank less than 9?
SQL: SELECT AVG("earnings") FROM lpga_players_2 WHERE "player" = 'meg mallon' AND "rank" < 9