select 
    f.film_id,
    f.title
from 
    film as f
left join 
    film_category as f_c
on 
    f.film_id = f_c.film_id
where 
    f_c.category_id is null