Use Adventureworks2014 Later Database Using Data Database Find List English Names Products Q43827738
Use Adventureworks2014 or later database
- Using the data in this database, find and list the Englishnames of the products purchased by customer 11037. Explain in yourown words how you found your answer and show your SQLstatement.
Production.Product Columns Keys TO PK_Product_ProductID oms FK_Product_ProductModel_ProductModells Coins FK_Product_ProductSubcategory_ProductSubcategoryID Cima FK_Product_UnitMeasure_SizeUnitMeasureCode cums FK_Product_UnitMeasure_WeightUnitMeasureCode Dalaudses + – Customer (Sales) CustomerlD PersonlD StorelD TerritoryID AccountNumber rowguid ModifiedDate System Databases Database Snapshots AdventureWorks2017 Database Diagrams Tables System Tables + File Tables + External Tables F Graph Tables + 1 dbo.AWBuildVersion dbo.DatabaseLog + Udbo.ErrorLog Human Resources.Department + Human Resources. Employee + Human Resources.Employee Department His Human Resources. EmployeePayHistory + Human Resources.JobCandidate + Human Resources. Shift + Person.Address + I Person.AddressType + Person.Business Entity Person.Business EntityAddress + Person.Business EntityContact + Person.ContactType Person.Country Region Person.Email Address + Person.Password Person.Person # Person.PersonPhone + Person.Phone NumberType # Person.State Province # Production.BillOfMaterials Production.Culture + ! Production. Document + Production.illustration Production.Location + Production.Product Production.ProductCategory + Production.ProductCost History Product (Production) 1 ProductID Name Product Number Make Flag Finished GoodsFlag Color Safety StockLevel ReorderPoint StandardCost List Price Size SizeUnitMeasureCode WeightUnitMeasureCode Weight DaysToManufacture ProductLine Class Style ProductSubcategoryID Product ModelID SellStartDate SellEndDate Discontinued Date rowguid Modified Date + Database Snapshots AdventureWorks2017 Database Diagrams Tables + System Tables + File Tables + External Tables Graph Tables + dbo.AWBuildVersion + 3 dbo.DatabaseLog + 3 dbo.Errorlog + Human Resources.Department + Human Resources. Employee + 3 Human Resources.Employee Department His + 5 Human Resources.EmployeePayHistory + 3 Human Resources.JobCandidate + 3 Human Resources.Shift + 5 Person.Address Person.Address Type # Person.Business Entity + Person.Business Entity Address + Person.Business EntityContact + 5 Person.ContactType + Person.Country Region + 5 Person.Email Address + Person.Password + 5 Person.Person + 5 Person.PersonPhone + Person.Phone NumberType + Person.State Province + Production.BillOfMaterials + Production.Culture + 5 Production.Document + 3 Production.Illustration + Production.Location B Production.Product + Columns – Keys Product (Production) 2 ProductID Name ProductNumber MakeFlag Finished GoodsFlag Color Safety StockLevel ReorderPoint Standard Cost ListPrice Size SizeUnitMeasureCode WeightUnitMeasureCode Weight DaysToManufacture ProductLine Class Style ProductSubcategoryID ProductModelID SellStartDate SellEndDate Discontinued Date rowguid ModifiedDate Show transcribed image text Production.Product Columns Keys TO PK_Product_ProductID oms FK_Product_ProductModel_ProductModells Coins FK_Product_ProductSubcategory_ProductSubcategoryID Cima FK_Product_UnitMeasure_SizeUnitMeasureCode cums FK_Product_UnitMeasure_WeightUnitMeasureCode
Dalaudses + – Customer (Sales) CustomerlD PersonlD StorelD TerritoryID AccountNumber rowguid ModifiedDate System Databases Database Snapshots AdventureWorks2017 Database Diagrams Tables System Tables + File Tables + External Tables F Graph Tables + 1 dbo.AWBuildVersion dbo.DatabaseLog + Udbo.ErrorLog Human Resources.Department + Human Resources. Employee + Human Resources.Employee Department His Human Resources. EmployeePayHistory + Human Resources.JobCandidate + Human Resources. Shift + Person.Address + I Person.AddressType + Person.Business Entity Person.Business EntityAddress + Person.Business EntityContact + Person.ContactType Person.Country Region Person.Email Address + Person.Password Person.Person # Person.PersonPhone + Person.Phone NumberType # Person.State Province # Production.BillOfMaterials Production.Culture + ! Production. Document + Production.illustration Production.Location + Production.Product Production.ProductCategory + Production.ProductCost History Product (Production) 1 ProductID Name Product Number Make Flag Finished GoodsFlag Color Safety StockLevel ReorderPoint StandardCost List Price Size SizeUnitMeasureCode WeightUnitMeasureCode Weight DaysToManufacture ProductLine Class Style ProductSubcategoryID Product ModelID SellStartDate SellEndDate Discontinued Date rowguid Modified Date
+ Database Snapshots AdventureWorks2017 Database Diagrams Tables + System Tables + File Tables + External Tables Graph Tables + dbo.AWBuildVersion + 3 dbo.DatabaseLog + 3 dbo.Errorlog + Human Resources.Department + Human Resources. Employee + 3 Human Resources.Employee Department His + 5 Human Resources.EmployeePayHistory + 3 Human Resources.JobCandidate + 3 Human Resources.Shift + 5 Person.Address Person.Address Type # Person.Business Entity + Person.Business Entity Address + Person.Business EntityContact + 5 Person.ContactType + Person.Country Region + 5 Person.Email Address + Person.Password + 5 Person.Person + 5 Person.PersonPhone + Person.Phone NumberType + Person.State Province + Production.BillOfMaterials + Production.Culture + 5 Production.Document + 3 Production.Illustration + Production.Location B Production.Product + Columns – Keys Product (Production) 2 ProductID Name ProductNumber MakeFlag Finished GoodsFlag Color Safety StockLevel ReorderPoint Standard Cost ListPrice Size SizeUnitMeasureCode WeightUnitMeasureCode Weight DaysToManufacture ProductLine Class Style ProductSubcategoryID ProductModelID SellStartDate SellEndDate Discontinued Date rowguid ModifiedDate
Expert Answer
Answer to Use Adventureworks2014 or later database Using the data in this database, find and list the English names of the product…
OR