SELECT title, directed_by FROM film WHERE NOT film_id IN (SELECT film_id FROM schedule)
What are the title and director of the films without any schedule?
CREATE TABLE schedule (
    title VARCHAR,
    directed_by VARCHAR,
    film_id VARCHAR
)

CREATE TABLE film (
    title VARCHAR,
    directed_by VARCHAR,
    film_id VARCHAR
)