CREATE TABLE channel (channel_id DECIMAL, name TEXT, owner TEXT, share_in_percent DECIMAL, rating_in_percent DECIMAL)
CREATE TABLE broadcast_share (channel_id DECIMAL, program_id DECIMAL, date TEXT, share_in_percent DECIMAL)
CREATE TABLE broadcast (channel_id DECIMAL, program_id DECIMAL, time_of_day TEXT)
CREATE TABLE program (program_id DECIMAL, name TEXT, origin TEXT, launch DECIMAL, owner TEXT)

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" AS "t1" JOIN "broadcast" AS "t2" ON "t1"."channel_id" = "t2"."channel_id" AND "t2"."time_of_day" = 'Morning' INTERSECT SELECT "t1"."name" FROM "channel" AS "t1" JOIN "broadcast" AS "t2" ON "t1"."channel_id" = "t2"."channel_id" AND "t2"."time_of_day" = 'Night'