Table: nhl_all_star_broadcasts
Columns: year
network
play_by_play
colour_commentator_s
ice_level_reporters
studio_host
studio_analysts

Question: Which studio analyst has Scott Oake for the ice level reporter?
SQL: SELECT "studio_analysts" FROM nhl_all_star_broadcasts WHERE "ice_level_reporters" = 'scott oake'

Question: Which ice level reporter has Harry Neale for the colour commentator after the year 2004?
SQL: SELECT "ice_level_reporters" FROM nhl_all_star_broadcasts WHERE "colour_commentator_s" = 'harry neale' AND "year" > 2004