human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: City, Station, Year acquired, Primary programming source, Other programming sources, Current status
###Question: how many channels were gained in 1997
gpt
SELECT COUNT Other programming sources FROM table WHERE Year acquired = 1997