Table: nhl_all_star_broadcasts_2
Columns: year
network
play_by_play
colour_commentator_s
studio_host

Question: Who was the colour commmentator that broadcasted along with the Play-by-play of bob cole?
SQL: SELECT "colour_commentator_s" FROM nhl_all_star_broadcasts_2 WHERE "play_by_play" = 'bob cole'

Question: Which network had the host of john wells?
SQL: SELECT "network" FROM nhl_all_star_broadcasts_2 WHERE "studio_host" = 'john wells'