How many were the show's average weekly ranking when it reached No. 2 in average nightly ranking?
CREATE TABLE table_15358729_6 (average_weekly_rank VARCHAR, average_nightly_rank VARCHAR)
SELECT COUNT(average_weekly_rank) FROM table_15358729_6 WHERE average_nightly_rank = "No. 2"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_15358729_6 (average_weekly_rank VARCHAR, average_nightly_rank VARCHAR) Question: How many were the show's average weekly ranking when it reached No. 2 in average nightly ranking? [/INST] SELECT COUNT(average_weekly_rank) FROM table_15358729_6 WHERE average_nightly_rank = "No. 2" </s>