3-4

-- Те, кто больше 7 раз снимался

SELECT px.actor_id
FROM (
       SELECT actr.actor_id, flc.film_id
       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 px
GROUP BY px.actor_id
HAVING COUNT(px.film_id) > 7

-- фильмы после 2013
SELECT mov.film_id
FROM movie AS mov
WHERE release_year > 2013
GROUP BY mov.film_id
ORDER BY mov.film_id



SELECT actor_id, COUNT(film_id)--,px.name
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 px
WHERE 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 (
                SELECT pz_2.actor_id
                FROM (
                       SELECT actr.actor_id, flc.film_id
                       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_2
                GROUP BY pz_2.actor_id
                HAVING COUNT(film_id) > 7 )
GROUP BY actor_id--, px.name
ORDER BY COUNT(DISTINCT film_id) DESC

-- Те, кто больше 7 раз снимался
SELECT pz_2.actor_id
FROM (
       SELECT actr.actor_id, flc.film_id
       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_2
GROUP BY pz_2.actor_id
HAVING COUNT(film_id) > 7