user: ### NOW ANSWER:
Question: How many of the episodes have Roger Goldby as the director?
Columns: ['Total#', 'Series#', 'Title', 'Writer', 'Director', 'Original air date']
Types: ['real', 'real', 'text', 'text', 'text', 'text']
Sample row: [27.0, 1.0, '" Total Eclipse "', 'Michael Chaplin', 'Douglas Mackinnon', '28March2009 , 6:50pm – 7:35pm']
SQL:

assistant: SELECT "Total#" FROM "Table" WHERE "Director" = 'Roger Goldby';