Which channels broadcast both in the morning and at night? Give me the channel names.
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'
channels broadcast both in the morning and at night refers to finding channels with broadcasts in both 'Morning' and 'Night' time_of_day; channel names refer to selecting the 'name' from channel; INTERSECT is used to find common channels between two different time_of_day conditions;