Table: tv_stations_edmonton
Columns: city
station
year_acquired
primary_programming_source
other_programming_sources
current_status

Question: how many channels were gained in 1997
SQL: SELECT COUNT("other_programming_sources") FROM tv_stations_edmonton WHERE "year_acquired" = 1997

Question: how any were gained as the chan
SQL: SELECT COUNT("year_acquired") FROM tv_stations_edmonton WHERE "station" = 'CHAN'

Question: how many is the minimum for citv
SQL: SELECT MIN("year_acquired") FROM tv_stations_edmonton WHERE "station" = 'CITV'

Question: where is citv located
SQL: SELECT "city" FROM tv_stations_edmonton WHERE "station" = 'CITV'

Question: which station is located in edmonton
SQL: SELECT "station" FROM tv_stations_edmonton WHERE "city" = 'Edmonton'