user: ### NOW ANSWER:
Question: What is the termination of mission date of the representative appointed by Franklin Pierce with a title of Chargé d'Affaires?
Columns: ['Representative', 'Title', 'Presentation of Credentials', 'Termination of Mission', 'Appointed by']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['John Appleton', "Chargé d'Affaires", 'January 3, 1849', 'May 4, 1849', 'James K. Polk']
SQL:

assistant: SELECT "Termination of Mission" FROM "Table" WHERE "Appointed by" = 'Franklin Pierce' AND "Title" = 'Chargé d''Affaires';