CREATE TABLE table_204_796 (id NUMBER, "network name" CLOB, "flagship" CLOB, "programming type" CLOB, "owner" CLOB, "affiliates" NUMBER)

which is the only station with 8 affiliates ?
SELECT "network name" FROM table_204_796 WHERE "affiliates" = 8
SELECT "network name" FROM "table_204_796" WHERE "affiliates" = 8