AdventureWorksLT2012. Class standard: All KEYWORDS such as SELECT, FROM, WHERE so on must be in all capital letters and on separate lines.

Use AdventureWorksLT2012

--1. List the last name, first name and email address of each customer in alphabetical order by company. -- 407 rows

--2. List all products by product name. Include all data about each product. -- 295 rows

--3. List all products showing product ID, product name, standard cost and list price in order -- by highest to lowest list price. -- 295 rows

--4. List the unique city, state/province and country/region and order alphabetically -- by country/region, state/province and city. -- 272 rows

--5. List all orders from the SalesLT.SalesOrderHeader table from -- most recent to oldest based on OrderDate. Include all data related to each order. -- 32 rows

--6. List the colors of AdventureWorks products. List each color only once and -- list the colors in alphabetical order. -- 10 rows

--7. List customer IDs for all customers that have placed orders with AdventureWorks. -- Use the SalesLT.SalesOrderHeader table and show each customer ID only once even if the customer -- has placed multiple orders. -- 32 rows