CREATE TABLE table_204_296 (id NUMBER, "rank" NUMBER, "athlete" CLOB, "qual" NUMBER, "final" NUMBER, "total" NUMBER, "notes" CLOB)

what is the number of athletes from the us ?
SELECT COUNT("athlete") FROM table_204_296 WHERE "athlete" = 'usa'
SELECT COUNT("athlete") FROM "table_204_296" WHERE "athlete" = 'usa'