SELECT
f.film_id,
f.title
FROM
film f
LEFT JOIN film_category fc ON f.film_id = fc.film_id
WHERE
fc.category_id IS NULL
SELECT
f.film_id,
f.title
FROM
film f
LEFT JOIN film_category fc ON f.film_id = fc.film_id
WHERE
fc.category_id IS NULL