Untitled

 avatar
unknown
plain_text
16 days ago
525 B
7
Indexable
SELECT 
c.name AS name_category
,COUNT (m.film_id) AS total_films
FROM category AS c
LEFT OUTER JOIN film_category AS fc ON c.category_id=fc.category_id
LEFT OUTER JOIN movie AS m ON fc.film_id=m.film_id
LEFT OUTER JOIN film_actor AS fa ON m.film_id=fa.film_id
WHERE fa.actor_id IN (
    SELECT actor_id
    FROM film_actor AS fa
    LEFT JOIN movie AS m ON fa.film_id=m.film_id
    WHERE release_year>2013
    GROUP BY actor_id
    HAVING COUNT(fa.film_id)>7
)
GROUP BY name_category
ORDER BY total_films DESC, name_category
Leave a Comment