Table: x_files_episodes
Columns: year
show
season
episode
episode_number
original_airdate

Question: What is the average Episode Number, when Original Airdate is March 21, 2010, and when Season is less than 3?
SQL: SELECT AVG("episode_number") FROM x_files_episodes WHERE "original_airdate" = 'march 21, 2010' AND "season" < 3

Question: What is Show, when Episode Number is 1, when Year is less than 2010, and when Original Airdate is January 20, 2008?
SQL: SELECT "show" FROM x_files_episodes WHERE "episode_number" = 1 AND "year" < 2010 AND "original_airdate" = 'january 20, 2008'

Question: What is the total number of Season(s), when Original Airdate is January 24, 1999, and when Year is less than 1999?
SQL: SELECT COUNT("season") FROM x_files_episodes WHERE "original_airdate" = 'january 24, 1999' AND "year" < 1999