CREATE TABLE table_203_305 (id NUMBER, "round" NUMBER, "#" NUMBER, "player" CLOB, "nationality" CLOB, "college/junior/club team  ( league ) " CLOB)

how many players are from the united states ?
SELECT COUNT("player") FROM table_203_305 WHERE "nationality" = 'united states'
SELECT COUNT("player") FROM "table_203_305" WHERE "nationality" = 'united states'