Please do the following sql script, question 5 part a,b,c,d,e

This is the table

--- 6 For vendor whose product sales exceeds $700, display the VendorID, VendorName and total amount of sales as "TotalSales" select 6; -- 7 Display the ProductID, Productname and Product Price of the cheapest product. select 7; -- 8 Display the ProductID, Productname and VendorName for products whose price is below average price of all products sorted by productid. select 8; 1 -- 9 Display the ProductID and Productname from products that have sold more than 2 (total quantity). Sort by ProductID select 9; -- 10 Display the ProductId for the product that has been sold the most (highest total quantity across all transactions). select 10; VENDOR VendorID VendorName PRODUCT ProductID ProductPrice ProductName VendorID (FK) CategoryID (FK) REGION RegionID Region Name CATEGORY CategoryID CategoryName STORE StoreID StoreZip RegionID (FK) INCLUDES ProductID (FK) TID (FK) Quantity SALES TRANSACTION TID TDate StoreID (FK) CustomerID (FK) CUSTOMER CustomerID CustomerName CustomerZip