List the names of all programs.
select name from program
Include their broadcast times.
select t1.name, t2.time_of_day from program as t1 join broadcast as t2 on t1.program_id = t2.program_id
Which ones are broadcasted in both morning and night?
select t1.name from program as t1 join broadcast as t2 on t1.program_id = t2.program_id where t2.time_of_day = 'Morning' intersect select t1.name from program as t1 join broadcast as t2 on t1.program_id = t2.program_id where t2.time_of_day = 'Night'
Who are the owners of these programs?
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"