CREATE TABLE table_20967430_2 (written_by VARCHAR, prod_code VARCHAR)

Name the written by for production code 4g07
SELECT written_by FROM table_20967430_2 WHERE prod_code = "4G07"
SELECT "written_by" FROM "table_20967430_2" WHERE "4G07" = "prod_code"