heeeeeeelp

SELECT ca.name AS name_category,
    COUNT(fc.film_id) AS total_films
FROM category AS ca
FULL OUTER JOIN film_category AS fc ON ca.category_id=fc.category_id
FULL OUTER JOIN film_actor AS fa ON fc.film_id=fa.film_id
WHERE fa.actor_id IN (
    SELECT faa.actor_id
    FROM film_actor AS faa
    INNER JOIN movie AS moo ON moo.film_id=faa.film_id
    WHERE moo.release_year > 2013
    GROUP BY faa.actor_id
    HAVING COUNT(moo.film_id) > 7
)
GROUP BY ca.category_id
ORDER BY total_films DESC, name_category;