Re: Untitled

From Светлана Шаронова, 2 Months ago, written in SQL, viewed 137 times. This paste is a reply to Untitled from Светлана Шаронова - view diff

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

Download Paste or View Raw

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

Replies to Re: Untitled

Title	Name	Language	When
Re: Re: Untitled	Commodious Monkey	sql	2 Months ago.

Reply to "Re: 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?