user: ### NOW ANSWER:
Question: which is the number of the season episode whose writer is R. Scott Gemmill and the Director is Ray Austin?
Columns: ['No. in series', 'No. in season', 'Title', 'Directed by', 'Written by', 'Original air date']
Types: ['real', 'real', 'text', 'text', 'text', 'text']
Sample row: [23.0, 1.0, '"We the People"', 'Les Landau', 'Donald P. Bellisario', 'January 3, 1997']
SQL:

assistant: SELECT "No. in season" FROM "Table" WHERE "Written by" = 'R. Scott Gemmill' AND "Directed by" = 'Ray Austin';