Below is an instruction that describes a task. Write a response that appropriately completes the request.

### Instruction:
How many were the show's average weekly ranking when it reached No. 2 in average nightly ranking?

### Inputs:
table_name: table, columns: ['Season', '# of Episodes', 'Timeslot', 'Season Premiere', 'Season Final', 'Peak Audience', 'Average Audience', 'Average Nightly Rank', 'Average Weekly Rank', 'Average Yearly Ranking']

### Response:
SELECT COUNT Average Weekly Rank FROM table WHERE Average Nightly Rank = No. 2