Re: Re: Untitled

From Melodic Marmoset, 11 Months ago, written in Plain Text, viewed 313 times. This paste is a reply to Re: Untitled from Trivial Goose - view diff
URL http://codebin.org/view/4b58d559 Embed
Download Paste or View Raw
  1. SELECT c.name AS name_category,
  2. COUNT(fc.film_id) AS total_films
  3. FROM category AS c
  4. LEFT OUTER JOIN film_category AS fc ON c.category_id = fc.category_id
  5. WHERE m.film_id IN
  6. (SELECT fa.actor_id,
  7. COUNT(m.film_id)
  8. FROM movie as m
  9. LEFT OUTER JOIN film_actor AS fa ON m.film_id = fa.film_id
  10. WHERE m.release_year > 2013
  11. GROUP BY actor_id
  12. HAVING COUNT(m.film_id) > 7)
  13. GROUP BY c.name;
  14.  

Replies to Re: Re: Untitled rss

Title Name Language When
Re: Re: Re: Untitled Rude Cockroach text 11 Months ago.

Reply to "Re: Re: Untitled"

Here you can reply to the paste above