CREATE TABLE table_204_832 (id NUMBER, "name" CLOB, "nationality" CLOB, "club" CLOB, "from" NUMBER, "until" CLOB)

how many total coaches on the list are from canada ?
SELECT COUNT(*) FROM table_204_832 WHERE "nationality" = 'canada'
SELECT COUNT(*) FROM "table_204_832" WHERE "nationality" = 'canada'