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

Note: Use Adventureworks2014 or later database

  1. 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.
  2. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!