which is the number of the season episode whose writer is R. Scott Gemmill and the Director is Ray Austin?
CREATE TABLE table_228973_3 (no_in_season VARCHAR, written_by VARCHAR, directed_by VARCHAR)
SELECT no_in_season FROM table_228973_3 WHERE written_by = "R. Scott Gemmill" AND directed_by = "Ray Austin"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_228973_3 (no_in_season VARCHAR, written_by VARCHAR, directed_by VARCHAR) Question: which is the number of the season episode whose writer is R. Scott Gemmill and the Director is Ray Austin? [/INST] SELECT no_in_season FROM table_228973_3 WHERE written_by = "R. Scott Gemmill" AND directed_by = "Ray Austin" </s>