What Volume:Issue that has Peter Cetera as the artist and was on top for longer than 1 week?
CREATE TABLE table_name_97 (volume VARCHAR, weeks_on_top VARCHAR, artist VARCHAR)
SELECT volume AS :issue FROM table_name_97 WHERE weeks_on_top > 1 AND artist = "peter cetera"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (volume VARCHAR, weeks_on_top VARCHAR, artist VARCHAR) Question: What Volume:Issue that has Peter Cetera as the artist and was on top for longer than 1 week? [/INST] SELECT volume AS :issue FROM table_name_97 WHERE weeks_on_top > 1 AND artist = "peter cetera" </s>