CREATE TABLE table_30977 ("Season no." FLOAT, "Series no." FLOAT, "Title" CLOB, "Directed by" CLOB, "Written by" CLOB, "Original air date" CLOB, "Production code" FLOAT, "U.S. viewers  ( millions ) " CLOB)

How many episodes were written by Warren Leight?
SELECT COUNT("Season no.") FROM table_30977 WHERE "Written by" = 'Warren Leight'
SELECT COUNT("Season no.") FROM "table_30977" WHERE "Written by" = 'Warren Leight'