Which Total has a Country of united states, and a Player of andy north?
CREATE TABLE "made_the_cut" (
  "player" text,
  "country" text,
  "year_s_won" text,
  "total" real,
  "to_par" text,
  "finish" text
);
SELECT AVG("total") FROM "made_the_cut" WHERE "country"='united states' AND "player"='andy north';