How many Totals have a CONCACAF of 0, and an MLS Cup smaller than 6?
CREATE TABLE "most_appearances" (
  "name" text,
  "years" text,
  "mls_cup" real,
  "u_s_open_cup" real,
  "concacaf" real,
  "other" real,
  "total" real
);
SELECT COUNT("total") FROM "most_appearances" WHERE "concacaf"=0 AND "mls_cup"<6;