Just as there are tables in SQL Server within our AdventureWorks2014
database for us to query on, there are also predefined views that are available for us to use; for all practical purposes, these views behave exactly the same as tables. The views are available at the following location within SQL Server:
The following script can be used to pull store information such as postal codes and the number of employees:
SELECT StoreAddress.City as 'City' ,StoreAddress.Name as 'Store Name' ,StoreAddress.PostalCode as 'Postal Code' ,sum(StoreDemo.NumberEmployees) as 'Number of Employees' FROM [AdventureWorks2014].[Sales].[vStoreWithAddresses] as StoreAddress INNER JOIN [AdventureWorks2014].[Sales].[vStoreWithDemographics] StoreDemo on StoreAddress.BusinessEntityID=StoreDemo.BusinessEntityID Group by StoreAddress.City ,StoreAddress.Name ,StoreAddress.PostalCode order...