Table: episodes_14
Columns: no
col
title
directed_by
written_by
canadian_air_date
u_s_air_date
production_code
canadian_viewers_million

Question: How many production codes have the title "the better man"?
SQL: SELECT COUNT("production_code") FROM episodes_14 WHERE "title" = '"The Better Man"'

Question: Who directed the episode that aired on July 29, 2011?
SQL: SELECT "directed_by" FROM episodes_14 WHERE "u_s_air_date" = 'July 29, 2011'

Question: How many air dates where directed by jim donovan?
SQL: SELECT COUNT("u_s_air_date") FROM episodes_14 WHERE "directed_by" = 'Jim Donovan'

Question: What is the smallest number?
SQL: SELECT MIN("col") FROM episodes_14

Question: Which air dates have 1.229 canadian viewers (millions)?
SQL: SELECT "u_s_air_date" FROM episodes_14 WHERE "canadian_viewers_million" = '1.229'