Which Wins is the highest one that has a Country of united states, and a Player of andy bean, and a Rank smaller than 4?
CREATE TABLE "leaders" (
  "rank" real,
  "player" text,
  "country" text,
  "earnings" real,
  "events" real,
  "wins" real
);
SELECT MAX("wins") FROM "leaders" WHERE "country"='united states' AND "player"='andy bean' AND "rank"<4;