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
Please list the names of all channels.
assistant
SELECT name FROM channel;
human
Include the time of day that they are broadcasted.
assistant
SELECT t1.name , t2.time_of_day FROM channel AS t1 JOIN broadcast AS t2 ON t1.channel_id = t2.channel_id ;