1 60 Points Inner Join Let Database 3 Tables Retailorder Skudata Ordernumber Storenumber S Q37132900

help please with this Database Assignment
1 (60 points) Inner Join Let a database have 3 tables: Retail_Order SKU_Data OrderNumber, StoreNumber, StoreZip, OrderMonth,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. 2. (40 points) Grouping Assume you have a table Student (ID, Name, [Grade Level], Age,

OR
OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.