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.