Untitled
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