SCHEMA:
CREATE TABLE table_name_49 (film VARCHAR, president VARCHAR, year VARCHAR)
USER:
What was the film of Richard Nixon as President in a year newer than 1996?

QUERY:
SELECT film FROM table_name_49 WHERE president = "richard nixon" AND year > 1996