Table: pga_tour_stats
Columns: rank
player
country
earnings
wins

Question: What's jim colbert's highest rank?
SQL: SELECT MAX("rank") FROM pga_tour_stats WHERE "player" = 'jim colbert'

Question: What's hale irwin's average rank?
SQL: SELECT AVG("rank") FROM pga_tour_stats WHERE "player" = 'hale irwin'