how many channels were gained in 1997
CREATE TABLE table_1397655_1 (other_programming_sources VARCHAR, year_acquired VARCHAR)
SELECT COUNT(other_programming_sources) FROM table_1397655_1 WHERE year_acquired = 1997
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1397655_1 (other_programming_sources VARCHAR, year_acquired VARCHAR) Question: how many channels were gained in 1997 [/INST] SELECT COUNT(other_programming_sources) FROM table_1397655_1 WHERE year_acquired = 1997 </s>