Table: good_news_ratings
Columns: episode_no
airdate
viewers
bbc_three_weekly_ranking
cable_rank

Question: How many items are listed under viewers column when the bbd three weekly ranking was 1?
SQL: SELECT COUNT("viewers") FROM good_news_ratings WHERE "bbc_three_weekly_ranking" = '1'

Question: What episode number had a cable ranking of 8?
SQL: SELECT MIN("episode_no") FROM good_news_ratings WHERE "cable_rank" = '8'

Question: What date did the episode air that had n/a for it's bbc three weekly ranking?
SQL: SELECT "airdate" FROM good_news_ratings WHERE "bbc_three_weekly_ranking" = 'N/A'

Question: What date did the episode air that had a ranking of 17 for cable?
SQL: SELECT "airdate" FROM good_news_ratings WHERE "cable_rank" = '17'