思路:
select后先把要的列名写好
根据条件,从表film_category中找需要的列名film_id
left join 表category,限制列名=Action
select title, description from film
where film_id in
(select film_id from film_category
left join category
on film_category.category_id= category.category_id
where name="Action")