使用子查询的方式找出属于Action分类的所有电影对应的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'
	)
);