A. Single Table Queries

1. Compose a query to list all products which have product finish of natural ash or cherry. For each product, show product ID, product name, product finish, and unit price. Sort them by unit price in descending order.
2. Compose a query that list the different raw materials used for the furniture. For each raw material, show the material description and the average unit price of the material. List the average unit price from the most expensive to the cheapest.
3. Compose a query that list the vendors who supply materials with sell price more than $10.00. For each vendor who supply materials with sell price more than $10.00, show the vendor ID and the total number of materials supplied by the vendor. Sort the results by the number of materials in ascending order.
4. Compose a query to show every raw material that has a total value of $1,000 or less. The total value of each raw material is calculated by multiplying the footage on hand and by the unit price of that raw material. For each raw material, show material ID, footage on hand, unit price, and the raw materials total value. Sort the results by the raw materials total value in ascending order.