human
Schema:
program (Program_ID, Name, Origin, Launch, Owner)
channel (Channel_ID, Name, Owner, Share_in_percent, Rating_in_percent)
broadcast (Channel_ID, Program_ID, Time_of_day)
broadcast_share (Channel_ID, Program_ID, Date, Share_in_percent)
Please answer with SQL.
assistant
Sure, I understand.
human
Hello! Could you provide me with a list of all of the channel IDs for which the 'time of day' is morning?
assistant
SELECT Channel_ID FROM broadcast WHERE Time_of_day = 'Morning';
human
Thank you for that! Could you update this list to include the channel name?
assistant
SELECT t1.name , t2.Channel_ID FROM channel AS t1 JOIN broadcast AS t2 ON t1.channel_id = t2.channel_id WHERE t2.time_of_day = 'Morning';
human
Excellent! Finally, can you show me what the ownership is of each of those stations?
assistant
SELECT t1.name , t2.Channel_ID , Owner FROM channel AS t1 JOIN broadcast AS t2 ON t1.channel_id = t2.channel_id WHERE t2.time_of_day = "Morning" ;