select f.film_id,f.title from
film as f left join film_category as fc on f.film_id = fc.film_id
left join category as c on c.category_id = fc.category_id
where fc.category_id is null and c.name is null

1.使用left 进行表连接
2. 找出为分类的使用is null 查找空值