CREATE TABLE table_204_871 (id NUMBER, "ano" CLOB, "title" CLOB, "role" CLOB, "channel" CLOB, "notes" CLOB)

how many canal 9 shows has this actress been on ?
SELECT COUNT(*) FROM table_204_871 WHERE "channel" = 'canal 9'
SELECT COUNT(*) FROM "table_204_871" WHERE "channel" = 'canal 9'