user: ### NOW ANSWER:
Question: Name the termination of mission for appointed by of Franklin Pierce
Columns: ['Representative', 'Title', 'Presentation of credentials', 'Termination of mission', 'Appointed by']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Heman Allen', 'Minister Plenipotentiary', 'April 23, 1824', 'July 31, 1827', 'James Monroe']
SQL:

assistant: SELECT "Termination of mission" FROM "Table" WHERE "Appointed by" = 'Franklin Pierce';