题解 | #使用子查询的方式找出属于Action分类的所有电影对应的title,descp#

select
    title,
    description
from
    film
where
    film_id in (
        select
            film_id
        from
            film_category
        where
            category_id in (
                select
                    category_id
                from
                    category
                where
                    name = 'Action'
            )
    )