三表联查, where 筛选出电影名为"Action"

select title,description 
    from film join film_category using(film_id)
    join category using(category_id)
    where name="Action"