Question: Note: Use Adventureworks2014 or later database Using the data in this database, find and list the full name and email address of the customer whose

Note: Use Adventureworks2014 or later database
- Using the data in this database, find and list the full name and 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 English names of the products purchased by customer 11037. Explain in your own words how you found your answer and show your SQL statement.
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
