CREATE TABLE table_203_455 (id NUMBER, "round" NUMBER, "#" NUMBER, "player" CLOB, "nationality" CLOB, "college/junior/club team  ( league ) " CLOB)

how many players are from canada ?
SELECT COUNT("player") FROM table_203_455 WHERE "nationality" = 'canada'
SELECT COUNT("player") FROM "table_203_455" WHERE "nationality" = 'canada'