CREATE TABLE table_203_756 (id NUMBER, "year" NUMBER, "title" CLOB, "role" CLOB, "network" CLOB, "notes" CLOB)

how many appearances have no role listed ?
SELECT COUNT(*) FROM table_203_756 WHERE "role" IS NULL
SELECT COUNT(*) FROM "table_203_756" WHERE "role" IS NULL