user: ### NOW ANSWER:
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?
Columns: ['No. in series', 'No. in season', 'Title', 'Directed by', 'Written by', 'Original air date']
Types: ['real', 'real', 'text', 'text', 'text', 'text']
Sample row: [42.0, 1.0, '"Truth and Consequences (Part 1)"', 'Grant Brown', 'Louise Crane-Bowes', '9February1999']
SQL:

assistant: SELECT "Written by" FROM "Table" WHERE "No. in series" > 66.0 AND "No. in season" < 39.0 AND "Title" = '"Memories by Moonlight"';