CREATE TABLE table_204_160 (id NUMBER, "rank" NUMBER, "name" CLOB, "nationality" CLOB, "time" CLOB, "notes" CLOB)

how many canadian swimmers were there ?
SELECT COUNT("name") FROM table_204_160 WHERE "nationality" = 'canada'
SELECT COUNT("name") FROM "table_204_160" WHERE "nationality" = 'canada'