[Solved]1 60 Points Inner Join Let Database 3 Tables Retailorder Sku Data Ordernumber Storenumber Q37132888

database management

1 (60 points) Inner Join Let a database have 3 tables: Retail_Order SKU Data OrderNumber, StoreNumber, StoreZip, OrderMonth, Orderyear, OrderTotal ) SKU, SKU_Description, Department, Buyer) -ID, OrderNumber, SKU, Quantity, Price, ExtendedPrice) 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: Retail_Order SKU Data OrderNumber, StoreNumber, StoreZip, OrderMonth, Orderyear, OrderTotal ) SKU, SKU_Description, Department, Buyer) -ID, OrderNumber, SKU, Quantity, Price, ExtendedPrice) 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.

Expert Answer

---

Answer to 1 (60 points) Inner Join Let a database have 3 tables: Retail_Order SKU Data OrderNumber, StoreNumber, StoreZip, OrderMo… . . .