Utilizing the Holt Distributors database design below, write SQL statements that will accurately and efficiently complete the following requests:

1. Create each table with the correct attributes and keys as indicated in the Entity Listing

2. Load at least one row in every table.

3. Load only "Mary" as Customer Name and required fields in the Customer Table.

4. Change the name from "Mary" to "Michelle" for the customer entered in #3.

5. Add Milwaukee for the City and 53201 as the Zip to the customer entered in #3.

6. Remove the customer entered in #3.

7. Change the commission rate for all sales reps to 17%.

8. Add a column named Status to the Vendor Table. This is to contain a 0 -10 value to represent their selection choice as a vendor.

9. List the customer name and phone number for all customers in alphabetical order.

10. Find the last name and first name for every customer who has a credit limit of at least $800.

11. Give the order number for every order placed by customer number 124 on 12/01/00.

12. Provide the part number, part description and the value of the items inventoried for those parts that have a reorder point greater than 10.

13. Find the customer number, last name, and first name for every customer whose first name begins with the letter "S". Display the name as one column titled "Name".

14. List the part number, part description, and units on hand of all parts whose number on hand is more than average.

15. What is the most expensive part in the database?

16. How many customers are in the database?

17. List the sum of the current balances for all customers for every sales rep. Order and group the results by sales rep number.

18. For every order placed on 12/22/02, list the order number and order date along with the customer number, last name, and first name who placed the order.

19. List the order number, order date, part number, part description, and quantity ordered for all orders in ascending sequence by order number.

20. List the part number, part description, unit price, and quantity on hand for every part that has a unit price greater than the unit price of any part on hand.

21. Find the sales rep number, last name, and first name for every sales rep that represents at least one customer with a credit limit of $2000.