Table: tv_show_episodes_4
Columns: series
title
directed_by
written_by
original_air_date
production_code
u_s_viewers_million

Question: How many episodes with the production code CA106 are there?
SQL: SELECT COUNT("written_by") FROM tv_show_episodes_4 WHERE "production_code" = 'CA106'

Question: Who was the director for episodes that were written be Matthew Lau?
SQL: SELECT "directed_by" FROM tv_show_episodes_4 WHERE "written_by" = 'Matthew Lau'

Question: How many episode were written by Brett Conrad?
SQL: SELECT COUNT("title") FROM tv_show_episodes_4 WHERE "written_by" = 'Brett Conrad'

Question: How many episodes were directed by Tim Matheson?
SQL: SELECT COUNT("original_air_date") FROM tv_show_episodes_4 WHERE "directed_by" = 'Tim Matheson'

Question: How many episodes were directed by Rod Hardy?
SQL: SELECT COUNT("original_air_date") FROM tv_show_episodes_4 WHERE "directed_by" = 'Rod Hardy'