user: ### NOW ANSWER:
Question: what is the year when the role/episode is David Duchovny?
Columns: ['Year', 'Category', 'Recipients and nominees', 'Role/Episode', 'Result']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [1996.0, 'Best Actor in a Leading Role – Drama Series', 'David Duchovny', 'Fox Mulder', 'Won']
SQL:

assistant: SELECT "Year" FROM "Table" WHERE "Role/Episode" = 'David Duchovny';