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

Question: who are the writer of the series episode number 170?
SQL: SELECT "written_by" FROM episodes_data WHERE "series_no" = 170

Question: which is the  maximun serie episode number when the millions of North American spectators is 3.14?
SQL: SELECT MAX("series_no") FROM episodes_data WHERE "u_s_viewers_millions" = '3.14'

Question: How many writers write the episode whose director is Jonathan Herron?
SQL: SELECT COUNT("written_by") FROM episodes_data WHERE "directed_by" = 'Jonathan Herron'

Question: which is the biggest production code?
SQL: SELECT MAX("production_code") FROM episodes_data

Question: who are the writers when the production code is 8011?
SQL: SELECT "written_by" FROM episodes_data WHERE "production_code" = 8011

Question: what is the name of the episode whose writer is Timothy J. Lea and the director is Norberto Barba?
SQL: SELECT "title" FROM episodes_data WHERE "written_by" = 'Timothy J. Lea' AND "directed_by" = 'Norberto Barba'