user: ### NOW ANSWER:
Question: How many were the show's average weekly ranking when it reached No. 2 in average nightly ranking?
Columns: ['Season', '# of Episodes', 'Timeslot', 'Season Premiere', 'Season Final', 'Peak Audience', 'Average Audience', 'Average Nightly Rank', 'Average Weekly Rank', 'Average Yearly Ranking']
Types: ['real', 'real', 'text', 'text', 'text', 'real', 'real', 'text', 'text', 'text']
Sample row: [1.0, 22.0, 'Tuesday 8:30pm', '26 August 2008', '24 March 2009', 2067000.0, 1904364.0, 'No. 1', 'No. 2', 'No. 1']
SQL:

assistant: SELECT COUNT("Average Weekly Rank") FROM "Table" WHERE "Average Nightly Rank" = 'No. 2';