Using Microsoft Access to test the queries, can someone help with the complete S
ID: 3742206 • Letter: U
Question
Using Microsoft Access to test the queries, can someone help with the complete SQL Statement based on their respective query? Thank you
Required for every SELECT stalement Requied forevenySELECT5 Codumn Table Names) Conditional Expression GROUP BY 3Cm List Condton Condidional HAVING 4 Colume List ORDER BY 6 INVENTORY WarehouseID AREHOUSE WarehouseID WarehouseCity RDER ITEM CATALOGSKU 2014 RETAIL ORDER OrderNumber StoreNumber StoreZIP OrderMonth OrderYear OrderTotal KU DATA KU CatalogID SKU Description CatalogPage SKU Description KU SKU Description SKU Quantity Price ExtendedPrice arehouseState Manager Buyer OuantityOnOrder DateOnExplanation / Answer
If you have any doubts, please give me comment...
-- 7)
SELECT *
FROM RETAIL_ORDER RO INNER JOIN ORDER_ITEM OI ON RO.OrderNumber = OI.OrderNumber
WHERE OrderYear = 2014
ORDER BY RO.OrderNumber, SKU;
-- 8)
SELECT Department, AVG(Price)
FROM SKU_DATA S INNER JOIN ORDER_ITEM OI ON S.SKU = OI.SKU
WHERE S.SKU = OI.SKU
GROUP BY Department;
-- 9)
SELECT Manager
FROM WAREHOUSE W, INVENTORY I, SKU_DATA S, ORDER_ITEM O
WHERE W.WarehouseID = I.WarehouseID AND I.SKU = S.SKU AND S.SKU = O.SKU
GROUP BY Manager
HAVING COUNT(*) = (
SELECT MAX(no_of_orders)
FROM (
SELECT Manager, COUNT(*) AS no_of_orders
FROM WAREHOUSE W, INVENTORY I, SKU_DATA S, ORDER_ITEM O
WHERE W.WarehouseID = I.WarehouseID AND I.SKU = S.SKU AND S.SKU = O.SKU GROUP BY Manager
) AS T
);
-- 10)
SELECT StoreNumber, COUNT(*) AS no_of_Departments
FROM RETAIL_ORDER R, ORDER_ITEM O, SKU_DATA S
WHERE R.OrderNumber = O.OrderNumber AND O.SKU = S.SKU
GROUP BY StoreNumber;
-- 11)
SELECT Buyer, SUM(extendedPrice) AS total_money
FROM ORDER_ITEM O INNER JOIN SKU_DATA S ON O.SKU = S.SKU
GROUP BY Buyer;
-- 12)
SELECT Manager, SUM(extendedPrice) AS total_money
FROM ORDER_ITEM O, SKU_DATA S, INVENTORY I, WARHOUSE W
WHERE O.OrderNumber = S.OrderNUmber AND S.SKU = I.SKU AND I.WarehouseID = W.WarehouseID
GROUP BY Manager;
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.