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