CREATE TABLE table_204_174 (id DECIMAL, "rank" DECIMAL, "name" TEXT, "nationality" TEXT, "result" DECIMAL, "notes" TEXT)

how many names are there ?
SELECT COUNT("name") FROM table_204_174
SELECT COUNT("name") FROM "table_204_174"