user: ### NOW ANSWER:
Question: When 123 is the number in series who is the director?
Columns: ['No. in series', 'No. in season', 'Title', 'Directed by', 'Written by', 'Original air date', 'Production code']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'real']
Sample row: [118.0, 1.0, '"Crazy Love"', 'Joel Zwick', 'Brian Bird & John Wierick', 'March 7, 1997', 465352.0]
SQL:

assistant: SELECT "Directed by" FROM "Table" WHERE "No. in series" = 123.0;