E5.1 Write the SQL queries that accomplish the following tasks in the ZAGI Retail Company Sales Department Database:

E.5.1.12 Display the ProductID, ProductName, and ProductPrice for Products whose VendorName is Pacifica Gear that were sold in the region whose RegionName is Tristate. Do not display the same information more than once (i.e., do not show the same product more than once). Sort the results by ProductID.

E5.1.13 Display the TID, CustomerName, and TDate for sales transactions involving a customer buying a product whose ProductName is Easy Boot.

E5.1.14 Display the RegionID, RegionName, and number of stores in the region for all regions.

E5.1.15 For each product category, display the CategoryID, CategoryName, and average price of a product in the category.

E5.1.16 For each product category, display the CategoryID and the total number of items purchased in the category.

E5.1.17 Display the RegionID, RegionName, and the total amount of sales (in dollars) in the region for all regions. Display the total amount of sales as AmountSpent."