CREATE TABLE channel (name VARCHAR2, channel_id VARCHAR2)
CREATE TABLE broadcast (channel_id VARCHAR2, time_of_day VARCHAR2)

what are the names of the channels that broadcast in both morning and 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'
SELECT "t1"."name" FROM "channel" "t1" JOIN "broadcast" "t2" ON "t1"."channel_id" = "t2"."channel_id" AND "t2"."time_of_day" = 'Morning' INTERSECT SELECT "t1"."name" FROM "channel" "t1" JOIN "broadcast" "t2" ON "t1"."channel_id" = "t2"."channel_id" AND "t2"."time_of_day" = 'Night'