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

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