Table: tv_episode_info
Columns: no_in_season
no_disc
title
directed_by
written_by
original_air_date

Question: What was the original air date of Stargate SG-1 written by Peter Deluise?
SQL: SELECT "original_air_date" FROM tv_episode_info WHERE "written_by" = 'Peter DeLuise'

Question: How many seasons did Peter Deluise direct Stargate SG-1?
SQL: SELECT MAX("no_in_season") FROM tv_episode_info WHERE "directed_by" = 'Peter DeLuise'

Question: Which number episode of season 6 was the title "Sight Unseen"?
SQL: SELECT MIN("no_in_season") FROM tv_episode_info WHERE "title" = '"Sight Unseen"'