Which MLS Cup has another larger than 9, and a Total smaller than 72?
CREATE TABLE "most_appearances" (
  "name" text,
  "years" text,
  "mls_cup" real,
  "u_s_open_cup" real,
  "concacaf" real,
  "other" real,
  "total" real
);
SELECT AVG("mls_cup") FROM "most_appearances" WHERE "other">9 AND "total"<72;