Table: world_series_broadcasts
Columns: year
network
play_by_play_announcers
s_color_commentator
pregame_hosts
pregame_analysts

Question: Who is the s color commentator when the pregame host is jon sciambi?
SQL: SELECT "s_color_commentator" FROM world_series_broadcasts WHERE "pregame_hosts" = 'Jon Sciambi'

Question: Who is the pregame host when the pregame analysts is  Dave Campbell and the year is 2001?
SQL: SELECT "pregame_hosts" FROM world_series_broadcasts WHERE "pregame_analysts" = 'Dave Campbell' AND "year" = 2001

Question: How many networks are listed when the year is 2008?
SQL: SELECT COUNT("network") FROM world_series_broadcasts WHERE "year" = 2008