List all channel names.
select name from channel
When are they broadcasted?
select t1.name, t2.time_of_day from channel as t1 join broadcast as t2 on t1.channel_id = t2.channel_id
Which ones are broadcasted in the morning?
select t1.name from channel as t1 join broadcast as t2 on t1.channel_id = t2.channel_id where t2.time_of_day = 'Morning'