Найти все фильмы категории Action с помощью подзапроса и вывести их title и description

CREATE TABLE IF NOT EXISTS film (
film_id SMALLINT(5) NOT NULL DEFAULT '0',
title VARCHAR(255) NOT NULL,
description TEXT,
PRIMARY KEY (film_id));

CREATE TABLE category (
category_id TINYINT(3) NOT NULL,
name VARCHAR(25) NOT NULL,
last_update TIMESTAMP,
PRIMARY KEY (category_id));

CREATE TABLE film_category (
film_id SMALLINT(5) NOT NULL,
category_id TINYINT(3) NOT NULL,
last_update TIMESTAMP);

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