CREATE TABLE channel (name VARCHAR(255), channel_id VARCHAR(255)); CREATE TABLE broadcast (channel_id VARCHAR(255), time_of_day VARCHAR(255))
what are the names of the channels that broadcast in both morning and night?
    
SQL: 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'