Excersize

From Ivan Kirilenkov, 4 Months ago, written in SQL, viewed 88 times.

URL http://codebin.org/view/00cb02d4 Embed

Download Paste or View Raw

SELECT
    c.name AS name_category,
    COUNT(DISTINCT fc.film_id) AS total_films 
FROM 
    film_category AS fc
JOIN
    category AS c
        ON fc.category_id = c.category_id
WHERE film_id IN (
    SELECT
        m.film_id
    FROM 
        movie AS m
    JOIN
        film_actor AS fa
            ON m.film_id = fa.film_id
    WHERE 1=1
        AND release_year > 2013
    GROUP BY 1
    HAVING COUNT(fa.actor_id) > 7
)
GROUP BY 1
ORDER BY 2 DESC, 1

Reply to "Excersize"

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?