Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_name_37 (termination_of_mission VARCHAR, appointed_by VARCHAR, title VARCHAR)

### Question ###
What is the termination of mission date of the representative appointed by Franklin Pierce with a title of chargé d'affaires?

### Accurate SQL ###

SELECT termination_of_mission FROM table_name_37 WHERE appointed_by = "franklin pierce" AND title = "chargé d'affaires"