CREATE TABLE table_204_293 (id NUMBER, "district" NUMBER, "name" CLOB, "party" CLOB, "district office" CLOB, "first elected" NUMBER)

how many total senators are there ?
SELECT COUNT("name") FROM table_204_293
SELECT COUNT("name") FROM "table_204_293"