CREATE TABLE table_204_665 (id NUMBER, "rank" NUMBER, "name" CLOB, "notability" CLOB, "birthplace" CLOB, "advocate" CLOB)

how many canadians listed were born in scotland ?
SELECT COUNT(*) FROM table_204_665 WHERE "birthplace" = 'scotland'
SELECT COUNT(*) FROM "table_204_665" WHERE "birthplace" = 'scotland'