CREATE TABLE table_42015 ("Name" CLOB, "Total" CLOB, "League" CLOB, "Canadian Championship" CLOB, "CONCACAF Champions League" CLOB)

What name has a CONCACAF Champions League of 2 (0) and also a Canadian Championship of 8 (0)?
SELECT "Name" FROM table_42015 WHERE "CONCACAF Champions League" = '2 (0)' AND "Canadian Championship" = '8 (0)'
SELECT "Name" FROM "table_42015" WHERE "CONCACAF Champions League" = '2 (0)' AND "Canadian Championship" = '8 (0)'