Table: episodes_bbc2
Columns: series_no
episode_no
title
directed_by
written_by
uk_ratings_bbc2_rank
original_air_date

Question: Name the total number directed by for " france : cap gris-nez to mont-saint-michel "
SQL: SELECT COUNT("directed_by") FROM episodes_bbc2 WHERE "title" = '" France : Cap Gris-Nez to Mont-Saint-Michel "'

Question: Name the written by for john trefor
SQL: SELECT "written_by" FROM episodes_bbc2 WHERE "directed_by" = 'John Trefor'