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

how many athletes had times under 8 minutes ?
SELECT COUNT("name") FROM table_204_893 WHERE "time" < 8
SELECT COUNT("name") FROM "table_204_893" WHERE "time" < 8