Please list the names of all channels.
select name from channel
Include the time of day that they are 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 broadcast 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'
Out of those channels, which ones also broadcast at night?
select t1.name from channel as t1 join broadcast as t2 on t1.channel_id = t2.channel_id where t2.time_of_day = 'Morning' intersect select t1.name from channel as t1 join broadcast as t2 on t1.channel_id = t2.channel_id where t2.time_of_day = 'Night'