[Solved]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, 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, Major, …, Write SQL statements: (1) (2) (3) Find the number of students in each [Grade Level]. Find the youngest age of the student in each major. Find the youngest age of the student in each grade level of each major. 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. 2. (40 points) Grouping Assume you have a table Student (ID, Name, [Grade Level], Age, Major, …, Write SQL statements: (1) (2) (3) Find the number of students in each [Grade Level]. Find the youngest age of the student in each major. Find the youngest age of the student in each grade level of each major.

Expert Answer

---

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