Note Use Adventureworks2014 Later Database Using Data Database Find List Full Name Email A Q43822759
Note: Use Adventureworks2014 or later database
- Using the data in this database, find and list the full nameand email address of the customer whose Customer ID is 11037.Explain in your own words how you found your answer.
- 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.
Customer (Sales) CustomerlD PersonlD StorelD TerritoryID Account Number rowguid ModifiedDate Person (Person) BusinessEntityID PersonType NameStyle Title FirstName MiddleName LastName Suffix Email Address (Person). BusinessEntityID EmailAddressID EmailAddress rowguid ModifiedDate EmailPromotion AdditionalContactinfo Demographics rowguid ModifiedDate Show transcribed image text Customer (Sales) CustomerlD PersonlD StorelD TerritoryID Account Number rowguid ModifiedDate Person (Person) BusinessEntityID PersonType NameStyle Title FirstName MiddleName LastName Suffix Email Address (Person). BusinessEntityID EmailAddressID EmailAddress rowguid ModifiedDate EmailPromotion AdditionalContactinfo Demographics rowguid ModifiedDate
Expert Answer
Answer to Note: Use Adventureworks2014 or later database Using the data in this database, find and list the full name and email a…
OR