Table: actors_presidents
Columns: year
category
president
nominee
film
result

Question: What was the category of Richard Nixon as President in a year prior to 2009?
SQL: SELECT "category" FROM actors_presidents WHERE "president" = 'richard nixon' AND "year" < 2009

Question: What is the film that Raymond Massey was nominated for?
SQL: SELECT "film" FROM actors_presidents WHERE "nominee" = 'raymond massey'

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