--从内层开始往外写，逻辑就很通顺了
select title, description
from film 
where film_id in (
    select film_id
    from film_category
    where category_id = (
        select category_id
        from category
        where name = 'Action'
    )
)