Which office was Richard M. Griffin vying for on the Greenback ticket?
CREATE TABLE table_name_97 (office VARCHAR, greenback_ticket VARCHAR)
SELECT office FROM table_name_97 WHERE greenback_ticket = "richard m. griffin"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (office VARCHAR, greenback_ticket VARCHAR) Question: Which office was Richard M. Griffin vying for on the Greenback ticket? [/INST] SELECT office FROM table_name_97 WHERE greenback_ticket = "richard m. griffin" </s>