Table: tv_episode_stats
Columns: no
title
directed_by
written_by
original_air_date
u_s_viewers_in_millions
18_49_rating_share

Question: What was the 18-49 rating share for the episode "pilot"?
SQL: SELECT "18_49_rating_share" FROM tv_episode_stats WHERE "title" = '"Pilot"'

Question: How many viewers (in millions) watched the episode written by deidre shaw?
SQL: SELECT "u_s_viewers_in_millions" FROM tv_episode_stats WHERE "written_by" = 'Deidre Shaw'

Question: What was the original air date of episode number 1?
SQL: SELECT "original_air_date" FROM tv_episode_stats WHERE "no" = 1