How many people wrote episode 9 in the season that was directed by Ernest Dickerson?
CREATE TABLE table_29219286_1 (written_by VARCHAR, directed_by VARCHAR, no_in_season VARCHAR)
SELECT COUNT(written_by) FROM table_29219286_1 WHERE directed_by = "Ernest Dickerson" AND no_in_season = 9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_29219286_1 (written_by VARCHAR, directed_by VARCHAR, no_in_season VARCHAR) Question: How many people wrote episode 9 in the season that was directed by Ernest Dickerson? [/INST] SELECT COUNT(written_by) FROM table_29219286_1 WHERE directed_by = "Ernest Dickerson" AND no_in_season = 9 </s>