What are the names of all programs?
select name from program
When are they broadcasted?
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 the morning?
select t1.name, t2.time_of_day from program as t1 join broadcast as t2 on t1.program_id = t2.program_id where t2.time_of_day = "Morning"
What about the ones that are not broadcasted in the morning?
select name from program except select t1.name from program as t1 join broadcast as t2 on t1.program_id = t2.program_id where t2.time_of_day = "Morning"