user: ### NOW ANSWER:
Question: Who was the director of the episode with series number 116?
Columns: ['No. in series', 'No. in season', 'Title', 'Directed by', 'Written by', 'Original air date', 'U.S. viewers (millions)']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text']
Sample row: [115.0, 1.0, '"The Longest Night (Part II)"', 'Edward Allen Bernero', 'Edward Allen Bernero', 'September22,2010', '14.13']
SQL:

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