Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Quantos canais de satélite analógicos a Sky [Analógico] possui?
 ###Tabelas: CREATE TABLE wru_division_one_east (wru_division_one_east_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Played VARCHAR, Won VARCHAR, Drawn VARCHAR, Lost VARCHAR, Points for VARCHAR, Points against VARCHAR, Tries for VARCHAR, Points VARCHAR) CREATE TABLE closed_and_aborted_television_providers (closed_and_aborted_television_providers_id AUTO_INCREMENT PRIMARY KEY, Provider VARCHAR, Years VARCHAR, Free or pay VARCHAR, No. of channels VARCHAR, Colour VARCHAR, Digital VARCHAR, Transmission VARCHAR) CREATE TABLE top_all-time_athletes_–_50_metres_–_men (top_all-time_athletes_–_50_metres_–_men_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Time VARCHAR, Athlete VARCHAR, Date VARCHAR, Place VARCHAR) CREATE TABLE 2010_boys'_team (2010_boys'_team_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Height VARCHAR, School VARCHAR, Hometown VARCHAR, College VARCHAR, NBA Draft VARCHAR) CREATE TABLE list_of_songs_released_in_2008 (list_of_songs_released_in_2008_id AUTO_INCREMENT PRIMARY KEY, Song title VARCHAR, Artist VARCHAR, Year VARCHAR, Genre VARCHAR, Single / Pack name VARCHAR, Release date VARCHAR, Family Friendly VARCHAR, Additional Rock Band 3 Features VARCHAR)  
SELECT No. of channels FROM closed_and_aborted_television_providers WHERE Transmission = analogue satellite AND Provider = sky [analogue]