CREATE TABLE table_204_620 (id NUMBER, "title" CLOB, "year" NUMBER, "language" CLOB, "role" CLOB, "notes" CLOB)

how many roles has this actor had ?
SELECT COUNT("role") FROM table_204_620
SELECT COUNT("role") FROM "table_204_620"