--- версия 3

SELECT pz.name, COUNT(pz.film_id)
FROM
    (SELECT actr.actor_id, flc.film_id, ctg.name
     FROM actor AS actr
         LEFT OUTER JOIN film_actor AS fla ON actr.actor_id = fla.actor_id
         LEFT OUTER JOIN film_category AS flc ON flc.film_id = fla.film_id
         LEFT OUTER JOIN category AS ctg ON flc.category_id = ctg.category_id ) AS pz
WHERE  (pz.film_id IN (
                       SELECT mov.film_id
                       FROM movie AS mov
                       WHERE release_year > 2013
                       GROUP BY mov.film_id
                       ORDER BY mov.film_id ))
    AND (pz.actor_id IN (
                         SELECT px.actor_id
                         FROM (
                                SELECT ac.actor_id, fc.film_id
                                FROM actor AS ac
                                LEFT OUTER JOIN film_actor AS fa ON ac.actor_id = fa.actor_id
                                LEFT OUTER JOIN film_category AS fc ON fc.film_id = fa.film_id
                                LEFT OUTER JOIN category AS ct ON fc.category_id = ct.category_id
                              ) AS px
                         GROUP BY px.actor_id
                         HAVING COUNT (px.film_id) > 7 ))
GROUP BY pz.name
ORDER BY COUNT(pz.film_id) DESC, pz.name