What is the party of the politician who left office on January 12, 1857
CREATE TABLE table_name_47 (party VARCHAR, left_office VARCHAR)
SELECT party FROM table_name_47 WHERE left_office = "january 12, 1857"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (party VARCHAR, left_office VARCHAR) Question: What is the party of the politician who left office on January 12, 1857 [/INST] SELECT party FROM table_name_47 WHERE left_office = "january 12, 1857" </s>