What year was the No. 7 charts?
CREATE TABLE table_name_32 (year INTEGER, charts VARCHAR)
SELECT AVG(year) FROM table_name_32 WHERE charts = "no. 7"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_32 (year INTEGER, charts VARCHAR) Question: What year was the No. 7 charts? [/INST] SELECT AVG(year) FROM table_name_32 WHERE charts = "no. 7" </s>