What was the film of Richard Nixon as President in a year newer than 1996?
CREATE TABLE table_name_49 (film VARCHAR, president VARCHAR, year VARCHAR)
SELECT film FROM table_name_49 WHERE president = "richard nixon" AND year > 1996
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_49 (film VARCHAR, president VARCHAR, year VARCHAR) Question: What was the film of Richard Nixon as President in a year newer than 1996? [/INST] SELECT film FROM table_name_49 WHERE president = "richard nixon" AND year > 1996 </s>