CREATE TABLE table_204_521 (id NUMBER, "rank" NUMBER, "name" CLOB, "nationality" CLOB, "time  ( hand ) " CLOB, "notes" CLOB)

how many athletes were faster than bill chisholm ?
SELECT COUNT("name") FROM table_204_521 WHERE "time (hand)" < (SELECT "time (hand)" FROM table_204_521 WHERE "name" = 'bill chisholm')
SELECT COUNT("name") FROM "table_204_521" WHERE "time (hand)" < (SELECT "time (hand)" FROM "table_204_521" WHERE "name" = 'bill chisholm')