What name has a CONCACAF Champions League of 2 (0) and also a Canadian Championship of 8 (0)?
CREATE TABLE "most_appearances" (
  "name" text,
  "total" text,
  "league" text,
  "canadian_championship" text,
  "concacaf_champions_league" text
);
SELECT "name" FROM "most_appearances" WHERE "concacaf_champions_league"='2 (0)' AND "canadian_championship"='8 (0)';