本题考查了子查询，通过母表film_id字段得到字表的属于Action分类的film_id,继而查询得到对应的title，description

# 使用子查询的方式找出属于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"
)