How much To par has a Total larger than 149, and a Country of united states, and a Year(s) won of 1997?
CREATE TABLE "missed_the_cut" (
  "player" text,
  "country" text,
  "year_s_won" text,
  "total" real,
  "to_par" real
);
SELECT SUM("to_par") FROM "missed_the_cut" WHERE "total">149 AND "country"='united states' AND "year_s_won"='1997';