CREATE TABLE table_203_481 (id NUMBER, "n\\u00b0" NUMBER, "name" CLOB, "position" CLOB, "date of birth" CLOB, "nationality" CLOB)

how many total names are listed as having french nationality ?
SELECT COUNT("name") FROM table_203_481 WHERE "nationality" = 'france'
SELECT COUNT("name") FROM "table_203_481" WHERE "nationality" = 'france'