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