Table: tv_episode_data_142
Columns: series_no
season_no
title
directed_by
written_by
original_air_date
production_code
u_s_viewers_millions

Question: Who were the authors of the episode first broadcast on August 10, 2012?
SQL: SELECT "written_by" FROM tv_episode_data_142 WHERE "original_air_date" = 'August 10, 2012'

Question: How many million people in the US viewed the episode titled "Behind the Scenes"?
SQL: SELECT "u_s_viewers_millions" FROM tv_episode_data_142 WHERE "title" = '"Behind the Scenes"'

Question: When was originally aired the episode with an audience of 1.57 million us viewers?
SQL: SELECT "original_air_date" FROM tv_episode_data_142 WHERE "u_s_viewers_millions" = '1.57'

Question: What season number was assigned to the episode identified with the production code 401? 
SQL: SELECT "season_no" FROM tv_episode_data_142 WHERE "production_code" = 401