CREATE TABLE table_29154676_1 (season_no VARCHAR2, written_by VARCHAR2)

How many episodes were written by Warren Leight?
SELECT COUNT(season_no) FROM table_29154676_1 WHERE written_by = "Warren Leight"
SELECT COUNT("season_no") FROM "table_29154676_1" WHERE "Warren Leight" = "written_by"