题解 | 使用join查询方式找出没有分类的电影id以及名称

SELECT 
    film_id,
    title
FROM film f
LEFT JOIN film_category fc USING (film_id)
WHERE category_id  IN  (
    SELECT category_id 
    FROM category c
    RIGHT JOIN film_category USING(category_id)
) IS NULL