What is the highest value for Other that has CONCACAF value of 0 a U.S. Open Cup larger than 0?
CREATE TABLE "most_goals" (
  "name" text,
  "years" text,
  "mls_cup" real,
  "u_s_open_cup" real,
  "concacaf" real,
  "other" real,
  "total" real
);
SELECT MAX("other") FROM "most_goals" WHERE "u_s_open_cup">0 AND "concacaf"=0;