Run SQL query to display the productid, productname, productprice for all

the products with names contain a dash (- ) and ends with the letters set.

2.  Run SQL query to display the ProductID, ProductName, ProductPrice, and

VendorName for the products from the all the vendors other than 'Outdoor

Adventures'. Sort the results by ProductPrice in a descending order.

3.  Run SQL query to display the RegionName, RegionID, and total number of

stores in the region for each region.

4. Run SQL query to display the TID and the total number of items (of all

products) sold within the transaction for all sales transactions whose total number of

items (of all products) sold within the transaction is between eight and ten.

5. Run SQL query to display tid, customerid, storeid, date for the

transactions that took place on January of 2020.

REGION RegionID Region Name Chicagoland Tristate T STORE StoreID S1 S2 S3 SALESTRANSACTION StoreZip 60600 60605 35400 PRODUCT ProductID 1X1 2X2 3X3 4X4 5X5 6X6 RegionID TID CustomerID StoreID T111 1-2-333 T222 2-3-444 T333 1-2-333 T444 3-4-555 T555 2-3-444 C T S1 S2 ProductName Zzz Bag Easy Boot Cosy Sock Dura Boot Tiny Tent Biggy Tent INCLUDES ProductID TID T111 1X1 2X2 3X3 1X1 4X4 2X2 4X4 5X5 6X6 TDate 1-Jan-2020 1-Jan-2020 2-Jan-2020 2-Jan-2020 2-Jan-2020 $100 $70 $15 $90 $150 $250 ProductPrice Quantity 1 T222 1 T333 5 T333 1 T444 1 T444 2 T555 4 T555 2 T555 1 PG MK MK PG MK MK CUSTOMER CustomerID 1-2-333 2-3-444 3-4-555 VendorID CategoryID CP FW FW FW CP CP Tina Tony Pam VENDOR VendorID PG MK CustomerName CATEGORY CategoryID CategoryName CP FW VendorName Pacific Gear Mountain King Camping Footwear CustomerZip 60137 60611 35401