题解 | #使用子查询#
使用子查询的方式找出属于Action分类的所有电影对应的title,description
https://www.nowcoder.com/practice/2f2e556d335d469f96b91b212c4c203e
SELECT f.title, f.description FROM film f LEFT JOIN film_category fc ON f.film_id = fc.film_id LEFT JOIN category c ON c.category_id = fc.category_id WHERE c.name = 'Action'