CREATE TABLE table_203_710 (id NUMBER, "genre" CLOB, "year" NUMBER, "title" CLOB, "episode" CLOB, "role" CLOB, "notes" CLOB)

how many short film roles has he acted in ?
SELECT COUNT(*) FROM table_203_710 WHERE "genre" = 'short film'
SELECT COUNT(*) FROM "table_203_710" WHERE "genre" = 'short film'