SELECT SELECT c.name as category_name,
count (fc.AS name_category,
COUNT(m.film_id) as AS total_films
FROM movie as m
LEFT JOIN film_actor AS fa ON m.film_id = fa.film_id
LEFT JOIN actor AS a ON fa.actor_id = a.actor_id
LEFT JOIN film_category as fc
AS fc ON fc.film_id = m.film_id
LEFT JOIN category as AS c ON fc.category_id = c.category_id
WHERE fc.film_id fa.actor_id IN
(
SELECT m.film_id
fa.actor_id
FROM movie as m
LEFT JOIN film_actor AS fa
LEFT JOIN movie as fa m ON m.fa.film_id = fa.m.film_id
WHERE m.release_year > 2013
AND fa.actor_id IN
(
SELECT actor_id
FROM film_actor
release_year>2013
GROUP BY actor_id
fa.actor_id
HAVING COUNT (film_id)>7
COUNT(fa.film_id)>7
)
)
GROUP BY category_name
name_category
ORDER BY total_films DESC, category_namename_category