Database management Test 3 1 (60 points) Inner Join Let a database have 3 tables: Retail Order OrderNumber, StoreNumber, StoreZip, OrderMonth, Orderyear, Order Total3 SKU, SKU_Description, Department, Buyer) ID, OrderNumber, SKU, Quantity, Price, ExtendedPrice) SKU Data Orderltem (1) Find Swimming Department’s Revenue. (2) List buyers who bought some items sold in Jan, 2004 (3) List revenue grouped by buyer to find out who is the best buyer. Show transcribed image text Database management Test 3 1 (60 points)
OR
OR