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

1、查询title，description：SELECT title, description
2、需要查询的表：FROM film
3、子查询：
SELECT film_id
FROM category JOIN film_category ON category.category_id = film_category_id
WHERE name = "Action"

4、串联：
SELECT title, description
FROM film
WHERE film.film_id IN
(SELECT film_id
FROM category JOIN film_category ON category.category_id = film_category_id
WHERE name = "Action")