Please do the following in sql script.

-- 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; 9 Display the ProductId and Productname from products that have sold more than 2 (total quantity). Sort by ProductID select 9