Who was the semi-final television commentator when the spokesperson was Colin Berry and the final television commentator was Pete Murray?
CREATE TABLE table_17766232_7 (semi_final_television_commentator VARCHAR, spokesperson VARCHAR, final_television_commentator VARCHAR)
SELECT semi_final_television_commentator FROM table_17766232_7 WHERE spokesperson = "Colin Berry" AND final_television_commentator = "Pete Murray"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: 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? [/INST] SELECT semi_final_television_commentator FROM table_17766232_7 WHERE spokesperson = "Colin Berry" AND final_television_commentator = "Pete Murray" </s>