How many years had a film that peaked at #10 in the UK?
CREATE TABLE table_name_1 (year VARCHAR, uk_peak_position VARCHAR)
SELECT COUNT(year) FROM table_name_1 WHERE uk_peak_position = "10"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_1 (year VARCHAR, uk_peak_position VARCHAR) Question: How many years had a film that peaked at #10 in the UK? [/INST] SELECT COUNT(year) FROM table_name_1 WHERE uk_peak_position = "10" </s>