Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_2941848_10 ( pregame_hosts VARCHAR, pregame_analysts VARCHAR, year VARCHAR )

### Question ###
Who is the pregame host when the pregame analysts is Dave Campbell and the year is 2001?

### Accurate SQL ###

SELECT pregame_hosts FROM table_2941848_10 WHERE pregame_analysts = "Dave Campbell" AND year = 2001