SELECT f.title, f.description
FROM film f
JOIN film_category fc
USING (film_id)
WHERE fc.category_id =
(SELECT c.category_id
FROM category c
WHERE c.name = 'Action')
SELECT f.title, f.description
FROM film f
JOIN film_category fc
USING (film_id)
WHERE fc.category_id =
(SELECT c.category_id
FROM category c
WHERE c.name = 'Action')