本题考察left join 和如何取非空值
select a.film_id,a.title from film a left join film_category b on a.film_id=b.film_id where b.category_id is null;
select a.film_id,a.title from film a left join film_category b on a.film_id=b.film_id where b.category_id is null;