CREATE TABLE table_28078 ("Series #" FLOAT, "Title" CLOB, "Directed by" CLOB, "Written by" CLOB, "Original air date" CLOB, "Production code" CLOB, "U.S. viewers  ( million ) " CLOB)

How many episodes with the production code CA106 are there?
SELECT COUNT("Written by") FROM table_28078 WHERE "Production code" = 'CA106'
SELECT COUNT("Written by") FROM "table_28078" WHERE "Production code" = 'CA106'