Table: world_series_broadcasts
Columns: year
network
play_by_play_announcer
color_commentator
s_field_reporter
pregame_hosts
pregame_analysts
trophy_presentation

Question: What is the highest year with field reporter Steve Lyons?
SQL: SELECT MAX("year") FROM world_series_broadcasts WHERE "s_field_reporter" = 'Steve Lyons'

Question: What is every pregame analyst with Chris Rose as trophy presenter?
SQL: SELECT "pregame_analysts" FROM world_series_broadcasts WHERE "trophy_presentation" = 'Chris Rose'

Question: Who is every play-by-play announcer when Chris Rose is the trophy presenter?
SQL: SELECT "play_by_play_announcer" FROM world_series_broadcasts WHERE "trophy_presentation" = 'Chris Rose'