Table: episodes_table_27
Columns: no_in_series
no_in_season
title
directed_by
written_by
original_air_date

Question: when was the premiere of the episode called "force recon"?
SQL: SELECT "original_air_date" FROM episodes_table_27 WHERE "title" = '"Force Recon"'

Question: which is the number of the season episode whose premiere was in january 3, 1997?
SQL: SELECT COUNT("no_in_season") FROM episodes_table_27 WHERE "original_air_date" = 'January 3, 1997'

Question: which is the number of the season episode whose writer is R. Scott Gemmill and the Director is Ray Austin?
SQL: SELECT "no_in_season" FROM episodes_table_27 WHERE "written_by" = 'R. Scott Gemmill' AND "directed_by" = 'Ray Austin'

Question: what is the name of the episode whose number of the series episode was 31?
SQL: SELECT "title" FROM episodes_table_27 WHERE "no_in_series" = 31