#17. Write a SELECT statement that returns one row for each category that has products with these columns:

#17.  Write a SELECT statement that returns one row for each category that has products with these columns:
The CategoryName column from the Categories table
The count of the products in the Products table
The list price of the most expensive product in the Products table
Sort the result set so the category with the most products appears first.

#16. Write a SELECT statement that returns these two columns:

#16.  Write a SELECT statement that returns these two columns:
CategoryName    The CategoryName column from the Categories table
ProductID    The ProductID column from the Products table
Return one row for each category that has never been used. Hint: Use an outer join and only return rows where the ProductID column contains a null value.

#15. Write a SELECT statement that returns the ProductName and ListPrice columns from the Products table.

#15.  Write a SELECT statement that returns the ProductName and ListPrice columns from the Products table.
Return one row for each product that has the same list price as another product. Hint: Use a self-join to check that the ProductID columns aren’t equal but the ListPrice column is equal.
Sort the result set by ProductName.

#14. Write a SELECT statement that joins the Customers, Orders, OrderItems, and Products tables. This statement should return these columns: LastName, FirstName, OrderDate, ProductName, ItemPrice, DiscountAmount, and Quantity.

#14.  Write a SELECT statement that joins the Customers, Orders, OrderItems, and Products tables. This statement should return these columns: LastName, FirstName, OrderDate, ProductName, ItemPrice, DiscountAmount, and Quantity.

Use aliases for the tables.
Sort the final result set by LastName, OrderDate, and ProductName.

#13. Write a SELECT statement that joins the Customers table to the Addresses table and returns these columns: FirstName, LastName, Line1, City, State, ZipCode.

#13.  Write a SELECT statement that joins the Customers table to the Addresses table and returns these columns: FirstName, LastName, Line1, City, State, ZipCode.
Return one row for each customer, but only return addresses that are the shipping address for a customer.

#12. Write a SELECT statement that returns these column names and data from the OrderItems table

#2.  Write a SELECT statement that returns these column names and data from the OrderItems table:
ItemID    The ItemID column
ItemPrice    The ItemPrice column
DiscountAmount    The DiscountAmount column
Quantity    The Quantity column
PriceTotal    A column that’s calculated by multiplying the item price with the quantity
DiscountTotal    A column that’s calculated by multiplying the discount amount with the quantity
ItemTotal    A column that’s calculated by subtracting the discount amount from the item price and then multiplying by the quantity
Only return rows where the ItemTotal is greater than 500.
Sort the result set by item total in descending sequence.

#11. Write a SELECT statement that returns one column from the Customers table named FullName that joins the LastName and FirstName columns.

#11.  Write a SELECT statement that returns one column from the Customers table named FullName that joins the LastName and FirstName columns.
Format this column with the last name, a comma, a space, and the first name like this:
Doe, John
Sort the result set by last name in ascending sequence.
Return only the contacts whose last name begins with letters from M to Z.