CREATE TABLE table_204_698 (id NUMBER, "name" CLOB, "lifetime" CLOB, "nationality" CLOB, "notable as" CLOB, "notes" CLOB)

who was canadian , van amstel or valiquette ?
SELECT "name" FROM table_204_698 WHERE "name" IN ('louis van amstel', 'max valiquette') AND "nationality" = 'canadian'
SELECT "name" FROM "table_204_698" WHERE "name" IN ('louis van amstel', 'max valiquette') AND "nationality" = 'canadian'