Untitled

From Светлана Шаронова, 1 Year ago, written in SQL, viewed 298 times.
URL http://codebin.org/view/906a9088 Embed
Download Paste or View Raw
  1. SELECT c.name AS category_name,
  2.        COUNT (fc.film_id) AS total_films
  3. FROM film_category AS fc
  4. LEFT JOIN category AS c ON fc.category_id = c.category_id
  5. WHERE fc.film_id IN
  6. (
  7.     SELECT m.film_id
  8.     FROM movie AS m
  9.     LEFT JOIN film_actor AS fa ON m.film_id = fa.film_id
  10.     WHERE m.release_year > 2013
  11.     AND fa.actor_id IN
  12. (
  13.     SELECT actor_id
  14.     FROM film_actor
  15.     GROUP BY actor_id
  16.     HAVING COUNT (film_id)>7
  17. )
  18. )
  19. GROUP BY category_name
  20. ORDER BY total_films DESC, category_name

Replies to Untitled rss

Title Name Language When
Re: Untitled Светлана Шаронова sql 1 Year ago.

Reply to "Untitled"

Here you can reply to the paste above