Question

2. Join (30) Let a database have 3 tables: Retail Order OrderNumber, StoreNumber, StoreZip, OrderMonth, Orderyear, OrderTotal) SKU, SKU_Description, Department, Buyer ID, OrderNumber, SKU, Quantity, Price, ExtendedPrice) SKU Data OrderItem (1) Find Camping Department's Revenue. 10. (2) List buyers who bought some items sold in a store with StoreNumber

Answer 1

[1]

SELECT Table1.Total AS Revenue
FROM (
SELECT T1.*
       FROM (
           SELECT OrderNumber , SUM(OrderTotal) as Total
           FROM Retail_ORDER
           GROUP BY OrderNumber
       ) AS T1
   ) AS Table1
         
JOIN
(
       SELECT T2.*
       FROM
       (
       SELECT OrderNumber, SKU
FROM OrderItem  
WHERE SKU IN (SELECT SKU FROM SKU_Data WHERE department like 'Campimg')          
       ) AS T2
   ) AS Table2
      
ON (Table1.OrderNumber = Table2.OrderNumber);  

[2]

SELECT C.Buyer
FROM Retail_ORDER AS A
JOIN       
OrderItem AS B
ON( A.OrderNumber = B.OrderNumber AND A.StoreNumber = 10)
JOIN
SKU_Data AS C
ON (B.SKU = C.SKU);