Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE MATERIALIZED VIEW rental_by_category
- AS
- SELECT c.name AS category,
- sum(p.amount) AS total_sales
- FROM (((((payment p
- JOIN rental r ON ((p.rental_id = r.rental_id)))
- JOIN inventory i ON ((r.inventory_id = i.inventory_id)))
- JOIN film f ON ((i.film_id = f.film_id)))
- JOIN film_category fc ON ((f.film_id = fc.film_id)))
- JOIN category c ON ((fc.category_id = c.category_id)))
- GROUP BY c.name
- ORDER BY sum(p.amount) DESC
- WITH NO DATA;
- base table
- payment
- rental
- inventory
- film
- film_category
- category
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement