What channels have stations that were affiliated in 2002?
CREATE TABLE table_11147852_1 (channel_tv___dt__ VARCHAR, year_of_affiliation VARCHAR)
SELECT channel_tv___dt__ FROM table_11147852_1 WHERE year_of_affiliation = "2002"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_11147852_1 (channel_tv___dt__ VARCHAR, year_of_affiliation VARCHAR) Question: What channels have stations that were affiliated in 2002? [/INST] SELECT channel_tv___dt__ FROM table_11147852_1 WHERE year_of_affiliation = "2002" </s>