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

WITH t1 AS (
    SELECT 
        f.film_id,
        f.title
    FROM film f
    LEFT JOIN film_category fc
    ON f.film_id = fc.film_id
    LEFT JOIN category c
    ON fc.category_id = c.category_id
    WHERE fc.category_id IS NULL
)
SELECT * FROM t1;