Please answer questions 4-7

SQL Assignment 4 Show the average price, lowest price and highest price for all products. Name the columns to match the function being used. Show the CustomerID and the Average Freight Charge for each customer. Name the Freight column "Average Freight Cost." Show the same information in step 2 but only for customers who have an average freight cost more than $100. 4. Show each Employee's ID along with their first and last name and their most recent order date. 5. Show the ProductID and the number of times the product has been ordered for products ordered more than 50 times. HINT: use the order items table ** 6. Display the OrderID, the pre-discount price (name the column Full Retail Price) for all orders and the final price (name the column Final Price) for all orders. **bonus points for displaying only 2 numbers to the right of the decimal in the Final Price Column*** 7. Northwind traders would like to know how many times each shipper has shipped each product. Write a select query that returns the ProductID, ProductName, ShipperID and Shipper name Company Name) and a field that shows how many times the ShipperID has been used for each product. SQL Assignment 4 Show the average price, lowest price and highest price for all products. Name the columns to match the function being used. Show the CustomerID and the Average Freight Charge for each customer. Name the Freight column "Average Freight Cost." Show the same information in step 2 but only for customers who have an average freight cost more than $100. 4. Show each Employee's ID along with their first and last name and their most recent order date. 5. Show the ProductID and the number of times the product has been ordered for products ordered more than 50 times. HINT: use the order items table ** 6. Display the OrderID, the pre-discount price (name the column Full Retail Price) for all orders and the final price (name the column Final Price) for all orders. **bonus points for displaying only 2 numbers to the right of the decimal in the Final Price Column*** 7. Northwind traders would like to know how many times each shipper has shipped each product. Write a select query that returns the ProductID, ProductName, ShipperID and Shipper name Company Name) and a field that shows how many times the ShipperID has been used for each product