这道题要求用子查询，所以最好的解题方式是用双子查询， 不能用连接， 代码如下

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")
 )