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

how many competitors competed in the semifinal 2 ?
SELECT COUNT("name") FROM table_204_547
SELECT COUNT("name") FROM "table_204_547"