Table: all_saints_episodes
Columns: no_in_series
no_in_season
title
directed_by
written_by
original_air_date

Question: With the title "Memories by Moonlight", and a less than 39 number in season, and a greater than 66 number in series, who was the written by?
SQL: SELECT "written_by" FROM all_saints_episodes WHERE "no_in_series" > 66 AND "no_in_season" < 39 AND "title" = '"memories by moonlight"'

Question: Who directed the episode that was greater than 74 in the series, and had "Life Class" as the title?
SQL: SELECT "directed_by" FROM all_saints_episodes WHERE "no_in_series" > 74 AND "title" = '"life class"'