Question: Use Adventureworks2014 or later database Using the data in this database, find and list the English names of the products purchased by customer 11037. Explain
Use Adventureworks2014 or later database
- Using the data in this database, find and list the English names of the products purchased by customer 11037. Explain in your own words how you found your answer and show your SQL statement.


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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
