user: Question: How many episodes were written by Warren Leight?
Columns: ['Season no.', 'Series no.', 'Title', 'Directed by', 'Written by', 'Original air date', 'Production code', 'U.S. viewers (millions)']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: [1.0, 188.0, '"Rispetto"', 'Jean de Segonzac', 'Rick Eid', 'May1,2011', 10004.0, '5.10']
SQL:

assistant: SELECT COUNT("Season no.") FROM "Table" WHERE "Written by" = 'Warren Leight';