Please do the following sql script, 13 create a view over the product, salestransaction, includes, customer, store, region tables with columns: tdate, productid, productname, productprice, quantity,...

Extracted text: Please do the following sql script, 13 create a view over the product, salestransaction, includes, customer, store, region tables with columns: tdate, productid, productname, productprice, quantity, customerid, customername, storeid, storezip, regionname create view 13; -- 14 Using the view created in question 13 Display ProductID, ProductName, ProductPrice for products sold in zip code "60600" sorted by ProductID 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; This is the table PRODUCT VENDOR ProductID ProductPrice ProductName VendorID (FK) CategoryID (FK) VendorID VendorName REGION RegionID RegionName CATEGORY CategoryID CategoryName STORE INCLUDES StoreID StoreZip RegionID (FK) ProductID (FK) TID (FK) Quantity CUSTOMER SALES TRANSACTION CustomerID TID CustomerName TDate CustomerZip StoreID (FK) CustomerID (FK)