select title,description
from (
select ff.title,ff.description,c.name
from film_category fc
join film ff
on fc.film_id=ff.film_id
join category c
on fc.category_id =c.category_id
) f
where f.name='Action';
select title,description
from (
select ff.title,ff.description,c.name
from film_category fc
join film ff
on fc.film_id=ff.film_id
join category c
on fc.category_id =c.category_id
) f
where f.name='Action';