What is the series # when the director is john showalter?
CREATE TABLE table_29747178_2 (series__number VARCHAR, directed_by VARCHAR)
SELECT series__number FROM table_29747178_2 WHERE directed_by = "John Showalter"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_29747178_2 (series__number VARCHAR, directed_by VARCHAR) Question: What is the series # when the director is john showalter? [/INST] SELECT series__number FROM table_29747178_2 WHERE directed_by = "John Showalter" </s>