Untitled

From Alex, 4 Months ago, written in Plain Text, viewed 88 times. This paste will give up the ghost in 1 Second.

URL http://codebin.org/view/a4b22215 Embed

Download Paste or View Raw

SELECT cat.name AS name_category, 
       count(fc.film_id) AS total_films
FROM category as cat
LEFT OUTER JOIN film_category AS fc ON cat.category_id=fc.category_id
WHERE fc.film_id IN (SELECT fa.film_id
        FROM film_actor as fa
        LEFT OUTER JOIN film_category AS fc ON fa.film_id=fc.film_id
        LEFT OUTER JOIN category AS c ON c.category_id=fc.category_id
        WHERE fa.actor_id IN (SELECT fa.actor_id
                      FROM movie as m
                      RIGHT OUTER JOIN film_actor AS fa ON m.film_id=fa.film_id
                      WHERE m.release_year>2013
                      GROUP BY fa.actor_id
                      HAVING count(m.film_id)>7
                      )
        GROUP BY fa.film_id,fc.category_id)   
GROUP BY cat.name
ORDER BY total_films DESC

Reply to "Untitled"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?