what is the year when the role/episode is david duchovny?
CREATE TABLE table_name_82 (year VARCHAR, role_episode VARCHAR)
SELECT year FROM table_name_82 WHERE role_episode = "david duchovny"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_82 (year VARCHAR, role_episode VARCHAR) Question: what is the year when the role/episode is david duchovny? [/INST] SELECT year FROM table_name_82 WHERE role_episode = "david duchovny" </s>