What is the average Top-25 that has a Top-10 less than 7, and the Tournament is the open championship, with a Top-5more than 1?
CREATE TABLE "summary" (
  "tournament" text,
  "wins" real,
  "top_5" real,
  "top_10" real,
  "top_25" real,
  "events" real,
  "cuts_made" real
);
SELECT AVG("top_25") FROM "summary" WHERE "top_10"<7 AND "tournament"='the open championship' AND "top_5">1;