CREATE TABLE broadcast (program_id VARCHAR2, Time_of_day VARCHAR2)
CREATE TABLE program (owner VARCHAR2, program_id VARCHAR2)

find the program owners that have some programs in both morning and night time.
SELECT t1.owner FROM program AS t1 JOIN broadcast AS t2 ON t1.program_id = t2.program_id WHERE t2.Time_of_day = "Morning" INTERSECT SELECT t1.owner FROM program AS t1 JOIN broadcast AS t2 ON t1.program_id = t2.program_id WHERE t2.Time_of_day = "Night"
SELECT "t1"."owner" FROM "program" "t1" JOIN "broadcast" "t2" ON "Morning" = "t2"."Time_of_day" AND "t1"."program_id" = "t2"."program_id" INTERSECT SELECT "t1"."owner" FROM "program" "t1" JOIN "broadcast" "t2" ON "Night" = "t2"."Time_of_day" AND "t1"."program_id" = "t2"."program_id"