user: Question: What is the Flagship of the Show Hosted by Rover (Shane French)?
Columns: ['Show', 'Host(s)', 'Flagship', 'Market', 'iHeartRadio']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Armstrong & Getty', 'Jack Armstrong, Joe Getty', 'KSTE', 'Sacramento', 'n/a']
SQL:

assistant: SELECT "Flagship" FROM "Table" WHERE "Host(s)" = 'Rover (Shane French)';