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

how many ranked swimmers were from the united states ?
SELECT COUNT(*) FROM table_204_834 WHERE "nationality" = 'united states'
SELECT COUNT(*) FROM "table_204_834" WHERE "nationality" = 'united states'