if the peak is 9, how many weeks was it in the top 10?
CREATE TABLE table_26400041_2 (weeks_in_top_10 INTEGER, peak VARCHAR)
SELECT MAX(weeks_in_top_10) FROM table_26400041_2 WHERE peak = 9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_26400041_2 (weeks_in_top_10 INTEGER, peak VARCHAR) Question: if the peak is 9, how many weeks was it in the top 10? [/INST] SELECT MAX(weeks_in_top_10) FROM table_26400041_2 WHERE peak = 9 </s>