SELECT title ,  directed_by FROM film WHERE film_id NOT IN (SELECT film_id FROM schedule)
What are the title and director of the films without any schedule?
SELECT title , directed_by FROM film WHERE film_id NOT IN ( SELECT film_id FROM schedule )
select title , directed_by from film where film_id not in ( select film_id from schedule )
What are the title and director of the films without any schedule ?