How many seasons did Peter Deluise direct Stargate SG-1?
CREATE TABLE table_15431959_1 (no_in_season INTEGER, directed_by VARCHAR)
SELECT MAX(no_in_season) FROM table_15431959_1 WHERE directed_by = "Peter DeLuise"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_15431959_1 (no_in_season INTEGER, directed_by VARCHAR) Question: How many seasons did Peter Deluise direct Stargate SG-1? [/INST] SELECT MAX(no_in_season) FROM table_15431959_1 WHERE directed_by = "Peter DeLuise" </s>