Table: tv_episode_data_89
Columns: no
title
directed_by
written_by
original_air_date
production_code
u_s_viewers_million

Question: Who were all the writers whose episodes had 0.97 million viewers?
SQL: SELECT "written_by" FROM tv_episode_data_89 WHERE "u_s_viewers_million" = '0.97'

Question: How many directors worked on the episode written by Brent Fletcher & Miranda Kwok?
SQL: SELECT COUNT("directed_by") FROM tv_episode_data_89 WHERE "written_by" = 'Brent Fletcher & Miranda Kwok'

Question: What was the title of the episode directed by Rowan Woods?
SQL: SELECT "title" FROM tv_episode_data_89 WHERE "directed_by" = 'Rowan Woods'

Question: How many episodes were viewed by 1.29 million people?
SQL: SELECT COUNT("no") FROM tv_episode_data_89 WHERE "u_s_viewers_million" = '1.29'