How many episodes were aired between October and November 2008?
between October and November 2008 refers to air_date BETWEEN '2008-10-01' and '2008-11-30'
SELECT COUNT(episode_id) FROM Episode WHERE air_date LIKE '2008-10%' OR air_date LIKE '2008-11%';