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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What was the film of Richard Nixon as President in a year newer than 1996? ### Input: CREATE TABLE table_name_49 (
    film VARCHAR,
    president VARCHAR,
    year VARCHAR
) ### Response: SELECT film FROM table_name_49 WHERE president = "richard nixon" AND year > 1996