user: ### NOW ANSWER:
Question: David James Elliott directed which episode number within the series?
Columns: ['No. in series', 'No. in season', 'Title', 'Directed by', 'Written by', 'Original air date']
Types: ['real', 'real', 'text', 'text', 'text', 'text']
Sample row: [206.0, 1.0, '"Hail and Farewell (Part 2)"', "Terrence O'Hara", 'Stephen Zito', 'September 24, 2004']
SQL:

assistant: SELECT "No. in series" FROM "Table" WHERE "Directed by" = 'David James Elliott';