Untitled
unknown
plain_text
2 years ago
610 B
6
Indexable
SELECT c.name AS name_category, COUNT(DISTINCT fa.film_id) AS total_films FROM category AS c LEFT JOIN film_category AS fc ON fc.category_id = c.category_id LEFT JOIN film_actor AS fa ON fa.film_id = fc.film_id LEFT JOIN actor AS a ON fa.actor_id = a.actor_id WHERE a.actor_id IN( SELECT a.actor_id FROM movie AS m LEFT JOIN film_actor AS fa ON fa.film_id=m.film_id LEFT JOIN actor AS a ON fa.actor_id=a.actor_id WHERE m.release_year > '2013' GROUP BY a.actor_id HAVING COUNT(a.actor_id) > 7 ) GROUP BY name_category ORDER BY total_films DESC, name_category;
Editor is loading...