CREATE TABLE table_name_49 (film VARCHAR2, president VARCHAR2, year VARCHAR2)

What was the film of Richard Nixon as President in a year newer than 1996?
SELECT film FROM table_name_49 WHERE president = "richard nixon" AND year > 1996
SELECT "film" FROM "table_name_49" WHERE "president" = "richard nixon" AND "year" > 1996