You are given a database in a MS Access file that contains data collected in an

Question

You are given a database in a MS Access file that contains data collected in an outdoor sports retail store. The retail store hired you as a data analyst to answer questions in order to help them make business decisions that will help them grow. Write the SQL statement for each query.

Table Name FROM 1 Conditional Expression WHERE2 GROUP BYCondstional HAVING 4 Colum Lise ORDER BY 6 KU DATA ATALOG SK WarehouseID SKU Quantity Price SKU Descriotion Department Buver SKU SKU Description StorezIP QuantityOnHand QuantityOnOrder Manager OrderYear OrderTotal Quer y Question Listall records from retail_order and order_itemtables for the year 2014. Sort SQL Statement 7 by order number and SKU of Order_Item For every department, show the average order item price 9 Which manager had the largest amount (quantity) of item-orders? 10 For every store (storeNumber), how many departments are there? 11 How much total money (extendedprice) did we make from each buyer? 12How much total money (extendedprice) was each manager responsible for?

Explanation / Answer

7. select * from RETAIL_ORDER R, ORDER_ITEM where OrderYear = 2014 and R.OrderNumber = O.OrderNumber

8. select Department, avg(Price) from ORDER_ITEM O, SKU_DATA S where O.SKU = S.SKU;

9. select Manager from WAREHOUSE W, WAREHOUSE W2, INVENTORY I where I.WarehouseID = W.WarehouseID and W.QuanitityOnOrder > w2.QuanitityOnOrder;

10. Select StoreNumber, count(Department) from RETAIL_ORDER R, ORDER_ITEM O, SKU_DATA S where R.OrderNumber = O.OrderNumber and O.SKU = S.SKU group by Department;

11. Select Price from ORDER_ITEM O, SKU_DATA S, INVENTORY I where S.SKU = I.SKU group by Buyer

12. Select Price from ORDER_ITEM O, WARE_HOUSE W, SKU_DATA S, INVENTORY I where S.SKU = I.SKU and I.WarehouseID = W.WarehouseId group by Manager

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.