What is the sum for the year with a location of newport, rhode island?
CREATE TABLE "u_s_open_champions" (
  "year" real,
  "country" text,
  "course" text,
  "location" text,
  "total_score" text,
  "to_par_a" text
);
SELECT SUM("year") FROM "u_s_open_champions" WHERE "location"='newport, rhode island';