A. Single Table Queries 1. List material ID, name, material, standard price, and thickness for raw materials made of cherry, pine, or walnut. Order the list by material, standard price, and thickness 2. Display the product line ID and the average standard price for all products in each product line ID. 3. List customer ID and total orders placed by each customer in 2018. 4. For every territory having more than one salesperson, display SalesTerritoryID and the number of salespersons in the territory. 5. What is the least expensive product finish? (Note: Measure it using average product standard price. Order the results ascendingly so the least expensive product can be identified easily.) 6. List minimum supply unit price of each vendor except vendorID 3. 7. For each product ID (except for product IDs 6 and 18), list all materials (material ID), the required quantity of each material used to create the product, and whose required quantity is greater than 3. 8. List ProductID, ProductDescription, ProductFinish, and ProductStandardPrice for Oak products with price > 400 or Cherry products with price