MySQL :: Sakila Sample Database :: 5.2.6 The sales_by_store View

Skip navigation links

Sakila Sample Database :: 5 Structure :: 5.2 Views :: 5.2.6 The sales_by_store View

« 5.2.5 The sales_by_film_category View

5.2.7 The staff_list View »

Section Navigation [Toggle]

5.2 Views
5.2.1 The actor_info View
5.2.2 The customer_list View
5.2.3 The film_list View
5.2.4 The nicer_but_slower_film_list View
5.2.5 The sales_by_film_category View
5.2.6 The sales_by_store View
5.2.7 The staff_list View

5.2.6. The sales_by_store View

The sales_by_store view provides a list of total sales, broken down by store.

The view returns the store location, manager name, and total sales.

The sales_by_store view incorporates data from the city, country, payment, rental, inventory, store, address, and staff tables.

Top / Previous / Next / Up / Table of Contents

© 2013, Oracle Corporation and/or its affiliates