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

the total number of players picked
SELECT COUNT("player") FROM table_204_140
SELECT COUNT("player") FROM "table_204_140"