Solved 1 Answer
See More Answers for FREE
Enhance your learning with StudyX
Receive support from our dedicated community users and experts
See up to 20 answers per week for free
Experience reliable customer service
Query   Select DT.TM_MONTH,P_CATEGORY,DF.P_CODE,sum(SALE_UNITS) as "NUMPROD", sum(SALE_UNITS*SALE_PRICE) as "TOTSALES" from DWPRODUCT DP join DWSALESFACT DF on DP.P_CODE=DF.P_CODE join DWTIME DT on DF.TM_ID=DT.TM_ID group by DT.TM_MONTH,P_CATEGORY,DF.P_CODE; ...