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