CREATE TABLE table_204_54 (id NUMBER, "pondicherry assembly" CLOB, "duration" CLOB, "name of m.l.a." CLOB, "party affiliation" CLOB, "election year" NUMBER)

how many were affiliated with the janata party ?
SELECT COUNT(*) FROM table_204_54 WHERE "party affiliation" = 'janata party'
SELECT COUNT(*) FROM "table_204_54" WHERE "party affiliation" = 'janata party'