Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT film.title, language.name, category.name, COUNT(DISTINCT film_actor.actor_id)
- 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