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