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_17766232_7 (semi_final_television_commentator VARCHAR, spokesperson VARCHAR, final_television_commentator VARCHAR)

### Question ###
Who was the semi-final television commentator when the spokesperson was Colin Berry and the final television commentator was Pete Murray?

### Accurate SQL ###

SELECT semi_final_television_commentator FROM table_17766232_7 WHERE spokesperson = "Colin Berry" AND final_television_commentator = "Pete Murray"