WITHTEMPas
(
SELECT
P.ProductID AS P_ID,
P.ProductName AS P_NAME,
P.Price AS Price,
SUM(OD.Quantity) AS SUMQ
FROM
OrderDetails as OD
INNERJOIN
Products as P
ON
OD.ProductID = P.ProductID
Groupby P.ProductID
)
SELECT P_ID, P_NAME, Price, SUMQ, Price*SUMQ as Revenue
FROMTEMPOrderby Revenue DESC;
WITH TEMP as ( SELECT P.ProductID AS P_ID, P.ProductName AS P_NAME, P.Price AS Price, SUM(OD.Quantity) AS SUMQ FROM OrderDetails as OD INNER JOIN Products as P ON OD.ProductID = P.ProductID Group by P.ProductID ) SELECT P_ID, P_NAME, Price, SUMQ, Price*SUMQ as Revenue FROM TEMP Order by Revenue DESC;
답글
(잘 보이지 않는 경우 이미지 오른쪽 마우스 클릭 => 새 탭에서 이미지 열기 하시면 됩니다.)
답글