user: ### NOW ANSWER:
Question: What is the resident state for the president elected in 1864?
Columns: ['Name', 'Election Year', 'Party', 'Birth State', 'Resident State']
Types: ['text', 'real', 'text', 'text', 'text']
Sample row: ['James K. Polk', 1844.0, 'Democrat', 'Lost North Carolina', 'Lost Tennessee']
SQL:

assistant: SELECT "Resident State" FROM "Table" WHERE "Election Year" = 1864.0;