Please do the following in sql script

This is the question 1 part a,b,c,d,e

and this is the table

-- 1 Display the RegionID, RegionName and number of stores in each region. select 1; -- 2 Display CategoryID and average price of products in that category. Use the ROUND function to show 2 digits after decimal point in average price. select 2; -- 3 Display CategoryID and number of items purchased in that category. select 3; -- 4 Display RegionID, RegionName and total amount of sales as "Amount Spent" select 4; -- 5 Display the TID and total number of items in the sale for all sales where the total number of items is greater than 3 select 5; 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