题解 | #使用子查询的方式找出属于Action分类

select
    f.title,
    f.description
from
    film f
where
    film_id in (
        select
            f.film_id
        from
            film f
            join film_category fc on fc.film_id = f.film_id
            join category c on c.category_id = fc.category_id
        where
            c.name = 'Action'
    )