Which studio analyst has Scott Oake for the ice level reporter?
CREATE TABLE table_name_52 (studio_analysts VARCHAR, ice_level_reporters VARCHAR)
SELECT studio_analysts FROM table_name_52 WHERE ice_level_reporters = "scott oake"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_52 (studio_analysts VARCHAR, ice_level_reporters VARCHAR) Question: Which studio analyst has Scott Oake for the ice level reporter? [/INST] SELECT studio_analysts FROM table_name_52 WHERE ice_level_reporters = "scott oake" </s>