Write SQL queries and snapshot of each query result as shwon above You can do only queries

Fantastic news! We've Found the answer you've been seeking!

Question:

Write SQL queries and snapshot of each query result as shwon above

You can do only queries as well

1. Retrieve the product ID, product name, category ID, and product price for each product in the FW product category, sorted by product price in descending order.

2. For each product, retrieve the ProductID value and the total number of product items sold within all sales transactions.

3. Retrieve all product with product name starting with “Tiny”.

4. Display the ProductID, ProductName, and ProductPrice for products in the category whose CategoryID value is ‘CP’. Sort the results by ProductID.

5. 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 greater than five.

Data:

INSERT INTO vendor VALUES ('PG','Pacifica Gear');
INSERT INTO vendor VALUES ('MK','Mountain King');
INSERT INTO vendor VALUES ('OA','Outdoor Adventures');
INSERT INTO vendor VALUES ('WL','Wilderness Limited');

INSERT INTO category VALUES ('CP','Camping');
INSERT INTO category VALUES ('FW','Footwear');
INSERT INTO category VALUES ('CL','Climbing');
INSERT INTO category VALUES ('EL','Electronics');
INSERT INTO category VALUES ('CY','Cycling');

INSERT INTO product VALUES ('1X1','Zzz Bag',100,'PG','CP');
INSERT INTO product VALUES ('2X2','Easy Boot',70,'MK','FW');
INSERT INTO product VALUES ('3X3','Cosy Sock',15,'MK','FW');
INSERT INTO product VALUES ('4X4','Dura Boot',90,'PG','FW');
INSERT INTO product VALUES ('5X5','Tiny Tent',150,'MK','CP');
INSERT INTO product VALUES ('6X6','Biggy Tent',250,'MK','CP');
INSERT INTO product VALUES ('7X7','Hi-Tec GPS',300,'OA','EL');
INSERT INTO product VALUES ('8X8','Power Pedals',20,'MK','CY');
INSERT INTO product VALUES ('9X9','Trusty Rope',30,'WL','CL');
INSERT INTO product VALUES ('1X2','Comfy Harness',150,'MK','CL');
INSERT INTO product VALUES ('1X3','Sunny Charger',125,'OA','EL');
INSERT INTO product VALUES ('1X4','Safe-T Helmet',40,'PG','CY');
INSERT INTO product VALUES ('2X1','Mmm Stove',80,'WL','CP');
INSERT INTO product VALUES ('2X3','Reflect-o Jacket',35,'PG','CY');
INSERT INTO product VALUES ('2X4','Strongster Carribeaner',20,'MK','CL');
INSERT INTO product VALUES ('3X1','Sleepy Pad',25,'WL','CP');
INSERT INTO product VALUES ('3X2','Bucky Knife',60,'WL','CP');
INSERT INTO product VALUES ('3X4','Treado Tire',30,'OA','CY');
INSERT INTO product VALUES ('4X1','Slicky Tire',25,'OA','CY');
INSERT INTO product VALUES ('4X2','Electra Compass',45,'MK','EL');
INSERT INTO product VALUES ('4X3','Mega Camera',275,'WL','EL');
INSERT INTO product VALUES ('5X1','Simple Sandal',50,'PG','FW');
INSERT INTO product VALUES ('5X2','Action Sandal',70,'PG','FW');
INSERT INTO product VALUES ('5X3','Luxo Tent',500,'OA','CP');

INSERT INTO region VALUES ('C','Chicagoland');
INSERT INTO region VALUES ('T','Tristate');
INSERT INTO region VALUES ('I','Indiana');
INSERT INTO region VALUES ('N','North');

INSERT INTO store VALUES ('S1','60600','C ');
INSERT INTO store VALUES ('S2','60605','C');
INSERT INTO store VALUES ('S3','35400','T');
INSERT INTO store VALUES ('S4','60640','C');
INSERT INTO store VALUES ('S5','46307','T');
INSERT INTO store VALUES ('S6','47374','I');
INSERT INTO store VALUES ('S7','47401','I');
INSERT INTO store VALUES ('S8','55401','N');
INSERT INTO store VALUES ('S9','54937','N');
INSERT INTO store VALUES ('S10','60602','C');
INSERT INTO store VALUES ('S11','46201','I');
INSERT INTO store VALUES ('S12','55701','N');
INSERT INTO store VALUES ('S13','60085','T');
INSERT INTO store VALUES ('S14','53140','T');

INSERT INTO customer VALUES ('1-2-333','Tina','60137');
INSERT INTO customer VALUES ('2-3-444','Tony','60611');
INSERT INTO customer VALUES ('3-4-555','Pam','35401');
INSERT INTO customer VALUES ('4-5-666','Elly','47374');
INSERT INTO customer VALUES ('5-6-777','Nora','60640');
INSERT INTO customer VALUES ('6-7-888','Miles','60602');
INSERT INTO customer VALUES ('7-8-999','Neil','55403');
INSERT INTO customer VALUES ('8-9-000','Maggie','47401');
INSERT INTO customer VALUES ('9-0-111','Ryan','46202');
INSERT INTO customer VALUES ('0-1-222','Dan','55499');

INSERT INTO salestransaction VALUES ('T111','1-2-333','S1','02-19-2016');
INSERT INTO salestransaction VALUES ('T222','2-3-444','S2','02-19-2016');
INSERT INTO salestransaction VALUES ('T333','1-2-333','S3','02-15-2016');
INSERT INTO salestransaction VALUES ('T444','3-4-555','S3','02-15-2016');
INSERT INTO salestransaction VALUES ('T555','2-3-444','S3','02-15-2016');
INSERT INTO salestransaction VALUES ('T666','5-6-777','S10','02-21-2016');
INSERT INTO salestransaction VALUES ('T777','6-7-888','S13','02-21-2016');
INSERT INTO salestransaction VALUES ('T888','8-9-000','S4','02-24-2016');
INSERT INTO salestransaction VALUES ('T999','4-5-666','S6','02-24-2016');
INSERT INTO salestransaction VALUES ('T101','7-8-999','S12','02-24-2016');
INSERT INTO salestransaction VALUES ('T202','0-1-222','S8','02-24-2016');
INSERT INTO salestransaction VALUES ('T303','4-5-666','S6','02-10-2016');
INSERT INTO salestransaction VALUES ('T404','8-9-000','S6','02-10-2016');
INSERT INTO salestransaction VALUES ('T505','6-7-888','S14','02-10-2016');
INSERT INTO salestransaction VALUES ('T606','0-1-222','S11','02-05-2016');
INSERT INTO salestransaction VALUES ('T707','5-6-777','S4','02-05-2016');
INSERT INTO salestransaction VALUES ('T808','7-8-999','S9','02-05-2016');
INSERT INTO salestransaction VALUES ('T909','5-6-777','S4','02-05-2016');
INSERT INTO salestransaction VALUES ('T011','8-9-000','S7','02-01-2016');
INSERT INTO salestransaction VALUES ('T022','9-0-111','S5','02-01-2016');

INSERT INTO soldvia VALUES ('1X1','T111',1);
INSERT INTO soldvia VALUES ('2X2','T222',1);
INSERT INTO soldvia VALUES ('3X3','T333',5);
INSERT INTO soldvia VALUES ('1X1','T333',1);
INSERT INTO soldvia VALUES ('4X4','T444',1);
INSERT INTO soldvia VALUES ('2X2','T444',2);
INSERT INTO soldvia VALUES ('4X4','T555',4);
INSERT INTO soldvia VALUES ('5X5','T555',2);
INSERT INTO soldvia VALUES ('6X6','T555',1);
INSERT INTO soldvia VALUES ('7X7','T666',1);
INSERT INTO soldvia VALUES ('9X9','T666',1);
INSERT INTO soldvia VALUES ('1X3','T666',2);
INSERT INTO soldvia VALUES ('8X8','T777',1);
INSERT INTO soldvia VALUES ('1X4','T888',4);
INSERT INTO soldvia VALUES ('2X3','T888',3);
INSERT INTO soldvia VALUES ('9X9','T999',1);
INSERT INTO soldvia VALUES ('1X2','T999',5);
INSERT INTO soldvia VALUES ('8X8','T999',3);
INSERT INTO soldvia VALUES ('1X3','T999',1);
INSERT INTO soldvia VALUES ('1X2','T101',3);
INSERT INTO soldvia VALUES ('1X4','T101',1);
INSERT INTO soldvia VALUES ('2X4','T202',4);
INSERT INTO soldvia VALUES ('9X9','T303',3);
INSERT INTO soldvia VALUES ('1X4','T303',2);
INSERT INTO soldvia VALUES ('2X1','T303',2);
INSERT INTO soldvia VALUES ('3X1','T303',2);
INSERT INTO soldvia VALUES ('2X4','T404',1);
INSERT INTO soldvia VALUES ('2X3','T404',2);
INSERT INTO soldvia VALUES ('2X2','T505',3);
INSERT INTO soldvia VALUES ('3X2','T505',1);
INSERT INTO soldvia VALUES ('2X1','T505',4);
INSERT INTO soldvia VALUES ('2X4','T606',7);
INSERT INTO soldvia VALUES ('3X1','T606',4);
INSERT INTO soldvia VALUES ('2X2','T606',3);
INSERT INTO soldvia VALUES ('3X4','T606',2);
INSERT INTO soldvia VALUES ('4X4','T606',2);
INSERT INTO soldvia VALUES ('3X2','T707',1);
INSERT INTO soldvia VALUES ('3X4','T707',4);
INSERT INTO soldvia VALUES ('4X1','T707',2);
INSERT INTO soldvia VALUES ('5X3','T808',1);
INSERT INTO soldvia VALUES ('4X2','T808',1);
INSERT INTO soldvia VALUES ('2X2','T808',1);
INSERT INTO soldvia VALUES ('4X3','T808',1);
INSERT INTO soldvia VALUES ('3X3','T808',4);
INSERT INTO soldvia VALUES ('4X2','T909',3);
INSERT INTO soldvia VALUES ('6X6','T909',1);
INSERT INTO soldvia VALUES ('3X3','T011',3);
INSERT INTO soldvia VALUES ('4X3','T022',3);
INSERT INTO soldvia VALUES ('2X2','T022',3);
INSERT INTO soldvia VALUES ('5X1','T022',2);