Оператор INNER JOIN, задача 6

--Отберите названия уникальных категорий фильмов, в которых снималась Эмили Ди (англ. Emily Dee).

SELECT DISTINCT(c.name)
FROM movie AS m
INNER JOIN film_category AS fc ON m.film_id = fc.film_id
INNER JOIN category AS c ON fc.category_id = c.category_id
INNER JOIN film_actor AS f ON fc.film_id = f.film_id
INNER JOIN actor AS a ON f.actor_id = a.actor_id
WHERE a.first_name = 'Emily'
  AND a.last_name = 'Dee';