CREATE TABLE table_204_664 (id NUMBER, "rank" NUMBER, "bib" NUMBER, "name" CLOB, "nationality" CLOB, "start" CLOB, "penalties  ( p+p+s+s ) " CLOB, "time" CLOB, "deficit" CLOB)

how many united states competitors did not win medals ?
SELECT COUNT(*) FROM table_204_664 WHERE "nationality" = 'united states' AND NOT "rank" IS NULL
SELECT COUNT(*) FROM "table_204_664" WHERE "nationality" = 'united states' AND NOT "rank" IS NULL