Table: tv_station_info_2
Columns: channel
station
video
aspect
psip_short_name
programming

Question: Which station has programming of Me-TV?
SQL: SELECT "station" FROM tv_station_info_2 WHERE "programming" = 'me-tv'

Question: Which station has programming of Me-TV?
SQL: SELECT "station" FROM tv_station_info_2 WHERE "programming" = 'me-tv'

Question: What is the short name having video of 720p and programming of Main KSTC-TV programming?
SQL: SELECT "psip_short_name" FROM tv_station_info_2 WHERE "video" = '720p' AND "programming" = 'main kstc-tv programming'

Question: What is the video associated with a short name of KSTCDT2?
SQL: SELECT "video" FROM tv_station_info_2 WHERE "psip_short_name" = 'kstcdt2'

Question: What is the short name of channel 5.5, KSTC-TV?
SQL: SELECT "psip_short_name" FROM tv_station_info_2 WHERE "station" = 'kstc-tv' AND "channel" = 5.5

Question: What is the short name of the channel under 5.2?
SQL: SELECT "psip_short_name" FROM tv_station_info_2 WHERE "channel" < 5.2