CREATE TABLE table_203_293 (id NUMBER, "years of appearance" CLOB, "title" CLOB, "network" CLOB, "character name" CLOB, "actor" CLOB, "notes" CLOB)

collectively , how many shows did hbo and mtv air ?
SELECT COUNT("title") FROM table_203_293 WHERE "network" IN ('hbo', 'mtv')
SELECT COUNT("title") FROM "table_203_293" WHERE "network" IN ('hbo', 'mtv')