Untitled

 avatar
unknown
plain_text
2 years ago
610 B
6
Indexable
SELECT c.name AS name_category,
      COUNT(DISTINCT fa.film_id) AS total_films
FROM category AS c
LEFT JOIN film_category AS fc ON fc.category_id = c.category_id
LEFT JOIN film_actor AS fa ON fa.film_id = fc.film_id
LEFT JOIN actor AS a ON fa.actor_id = a.actor_id

WHERE a.actor_id IN(
    SELECT a.actor_id
    FROM movie AS m
    LEFT JOIN film_actor AS fa ON fa.film_id=m.film_id
    LEFT JOIN actor AS a ON fa.actor_id=a.actor_id
    WHERE m.release_year > '2013'
    GROUP BY a.actor_id
    HAVING COUNT(a.actor_id) > 7
)
GROUP BY name_category
ORDER BY total_films DESC, name_category;
Editor is loading...