5.2.5 The sales_by_film_category View

The sales_by_film_category view provides a list of total sales, broken down by individual film category.

Because a film can be listed in multiple categories, it is not advisable to calculate aggregate sales by totalling the rows of this view.

The sales_by_film_category view incorporates data from the category, payment, rental, inventory, film, film_category, and category tables.

Download this Manual
PDF (US Ltr) - 177.1Kb
PDF (A4) - 176.7Kb