-- Database schema
| program : Program_ID [ INT ] primary_key , Name [ TEXT ] , Origin [ TEXT ] , Launch [ INT ] , Owner [ TEXT ] | channel : Channel_ID [ INT ] primary_key , Name [ TEXT ] , Owner [ TEXT ] , Share_in_percent [ INT ] , Rating_in_percent [ INT ] | broadcast : Channel_ID [ INT ] primary_key broadcast.Channel_ID = channel.Channel_ID , Program_ID [ INT ] broadcast.Program_ID = program.Program_ID , Time_of_day [ TEXT ] | broadcast_share : Channel_ID [ INT ] primary_key broadcast_share.Channel_ID = channel.Channel_ID , Program_ID [ INT ] broadcast_share.Program_ID = program.Program_ID , Date [ TEXT ] , Share_in_percent [ INT ] |
-- -- Who are the owners of the programs that broadcast both in the morning and at night?

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";