database management
1 (60 points) Inner Join 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 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 1 (60 points) Inner Join Let a database have 3 tables:
OR
OR