^{please do the following as}sql script.

13 create a view over the product, salestransaction, includes, customer, store, region tables with columns : tdate, productid, productname, productorice, quantity, customerid, customername, storeid, storezip, regionname create view 13; -- 14 Using the view created in question 13 Display ProductID, ProductName, Product Price for products sold in zip code "60600" sorted by Product ID select 14; -- -- -- 15 Using the view from question 13 display CustomerName and TDate for any customer buying a product "Easy Boot" select 15; -- 16 Using the view from question 13 display RegionName and total amount of sales in each region as "AmountSpent" select 16