Table: tv_station_ownership
Columns: city_of_license_market
station
channel_tv_dt
years_owned
current_affiliation

Question: What channel tv (dt) plays the KPIX station?
SQL: SELECT "channel_tv_dt" FROM tv_station_ownership WHERE "station" = 'KPIX'

Question: Which city of license/market has 3 (26) as their channel tv (dt)?
SQL: SELECT "city_of_license_market" FROM tv_station_ownership WHERE "channel_tv_dt" = '3 (26)'

Question: Which channel tv (dt) plays in San Francisco - Oakland - San Jose?
SQL: SELECT "channel_tv_dt" FROM tv_station_ownership WHERE "city_of_license_market" = 'San Francisco - Oakland - San Jose'

Question: How many years has station KPIX been owned?
SQL: SELECT COUNT("years_owned") FROM tv_station_ownership WHERE "station" = 'KPIX'

Question: Which city of license/market plays 3 (26)?
SQL: SELECT "city_of_license_market" FROM tv_station_ownership WHERE "channel_tv_dt" = '3 (26)'

Question: Who currently affiliates in San Francisco - Oakland - San Jose?
SQL: SELECT "current_affiliation" FROM tv_station_ownership WHERE "city_of_license_market" = 'San Francisco - Oakland - San Jose'