思想:
题目要求使用子查询的方式找出属于Action分类的所有电影对应的title,description。
首先通过条件(select category_id from category where name='Action')找出属于Action分类的分类id
其次通过条件(select film_id from film_category where category_id in (select category_id from category where name='Action'));找出属于Action分类的电影id
最后取出title,description
select title,description from film where film_id in
(select film_id from film_category where category_id in (select category_id from category where name='Action'));