CREATE TABLE table_204_712 (id NUMBER, "rank" NUMBER, "athlete" CLOB, "nationality" CLOB, "time" CLOB, "notes" CLOB)

how many competitors were from russia ?
SELECT COUNT("athlete") FROM table_204_712 WHERE "nationality" = 'russia'
SELECT COUNT("athlete") FROM "table_204_712" WHERE "nationality" = 'russia'