Table: radio_show_data
Columns: show
host_s
flagship
market
iheartradio

Question: What is the Flagship of the Show Hosted by Rover (Shane French)?
SQL: SELECT "flagship" FROM radio_show_data WHERE "host_s" = 'rover (shane french)'

Question: What is the Host of the Show with a Market of New York?
SQL: SELECT "host_s" FROM radio_show_data WHERE "market" = 'new york'

Question: What is the iHeartRadio of the Bronson and Christine Show?
SQL: SELECT "iheartradio" FROM radio_show_data WHERE "show" = 'bronson and christine'