Advertisement
Guest User

Untitled

a guest
Oct 14th, 2019
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT film.title, language.name, category.name, COUNT(DISTINCT film_actor.actor_id)
  2. FROM rental INNER JOIN inventory ON rental.inventory_id = inventory.inventory_id INNER JOIN film ON inventory.film_id = film.film_id INNER JOIN language ON film.language_id = language.language_id INNER JOIN film_category ON film.film_id = film_category.film_id INNER JOIN category ON film_category.category_id = category.category_id INNER JOIN film_actor ON film.film_id = film_actor.film_id GROUP BY film.title, language.name, category.name ORDER BY film.title
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement