What is the location for the club trophy from the year 1867 only?
CREATE TABLE table_name_52 (location VARCHAR, type VARCHAR, years VARCHAR)
SELECT location FROM table_name_52 WHERE type = "club trophy" AND years = "1867 only"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_52 (location VARCHAR, type VARCHAR, years VARCHAR) Question: What is the location for the club trophy from the year 1867 only? [/INST] SELECT location FROM table_name_52 WHERE type = "club trophy" AND years = "1867 only" </s>