How many chart runs had a debut position of more than 7 when peak position was 11?
CREATE TABLE table_name_18 (chart VARCHAR, debut_position VARCHAR, peak_position VARCHAR)
SELECT COUNT(chart) AS run FROM table_name_18 WHERE debut_position > 7 AND peak_position = 11
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_18 (chart VARCHAR, debut_position VARCHAR, peak_position VARCHAR) Question: How many chart runs had a debut position of more than 7 when peak position was 11? [/INST] SELECT COUNT(chart) AS run FROM table_name_18 WHERE debut_position > 7 AND peak_position = 11 </s>