What are the title and director of the films without any schedule?
create table schedule (title varchar, directed_by varchar, film_id varchar, PRIMARY KEY (title)); create table film (title varchar, directed_by varchar, film_id varchar, PRIMARY KEY (title))
select title, directed_by from film where not film_id in (select film_id from schedule)