# 使用子查询的方式找出属于Action分类的所有电影对应的title,description
SELECT f.title, f.description
FROM film AS f
WHERE film_id IN (
            SELECT fc.film_id FROM film_category AS fc INNER JOIN category AS c
    ON fc.category_id = c.category_id AND c.name = "Action"
)