user: ### NOW ANSWER:
Question: how many channels were gained in 1997
Columns: ['City', 'Station', 'Year acquired', 'Primary programming source', 'Other programming sources', 'Current status']
Types: ['text', 'text', 'real', 'text', 'text', 'text']
Sample row: ['Edmonton', 'CITV', 1991.0, 'Global', 'WIC', 'Global O&O']
SQL:

assistant: SELECT COUNT("Other programming sources") FROM "Table" WHERE "Year acquired" = 1997.0;