Table: episode_data_6
Columns: no_in_series
no_in_season
title
directed_by
written_by
original_air_date

Question: When did the episode directed by David Duchovny originally air?
SQL: SELECT "original_air_date" FROM episode_data_6 WHERE "directed_by" = 'David Duchovny'

Question: What's the title of the episode directed by David von Ancken, with a episode number bigger than 16.0?
SQL: SELECT "title" FROM episode_data_6 WHERE "directed_by" = 'David Von Ancken' AND "no_in_series" > 16.0

Question: How many episodes have been directed by David Duchovny?
SQL: SELECT COUNT("title") FROM episode_data_6 WHERE "directed_by" = 'David Duchovny'

Question: What's the smallest episode number of an episode whose number in the series is 22?
SQL: SELECT MIN("no_in_season") FROM episode_data_6 WHERE "no_in_series" = 22