Table: nhl_all_star_broadcasts_2
Columns: year
network
play_by_play
colour_commentator_s
studio_host

Question: Which network has a play-by-play announcer of John Wells?
SQL: SELECT "network" FROM nhl_all_star_broadcasts_2 WHERE "play_by_play" = 'john wells'

Question: On CBC, who was the colour commentator in 1987?
SQL: SELECT "colour_commentator_s" FROM nhl_all_star_broadcasts_2 WHERE "network" = 'cbc' AND "year" = 1987

Question: Who was the colour commentator when the play-by-play announcer was Bob Cole?
SQL: SELECT "colour_commentator_s" FROM nhl_all_star_broadcasts_2 WHERE "play_by_play" = 'bob cole'

Question: Who is the studio host that has a play-by-play announcer of Bob Cole and a colour commentator of Harry Neale?
SQL: SELECT "studio_host" FROM nhl_all_star_broadcasts_2 WHERE "play_by_play" = 'bob cole' AND "colour_commentator_s" = 'harry neale'

Question: In 1981, with a studio host of Dave Hodge, who was the colour commentator?
SQL: SELECT "colour_commentator_s" FROM nhl_all_star_broadcasts_2 WHERE "studio_host" = 'dave hodge' AND "year" = 1981