What is thesql command to list the total sales by customer , month , and product, with subtotals by customer and by month and a grand total for all product sales

The answer is below

Explanation:

The the sql command to list the total sales by customer , month , and product, with subtotals by customer and by month and a grand total for all product sales is:

SELECT S.CUS_CODE, T.TM_MONTH, S.P_CODE,

SUM(S.SALE_UNITS*S.SALE_PRICE) AS "TOTSALES"

FROM DWDAYSALESFACT AS S INNER JOIN DWTIME AS T ON S.TM_ID =

T.TM_ID

GROUP BY S.CUS_CODE,T.TM_MONTH,S.P_CODE WITH ROLLUP;

amazon is a website were you shop cosmetics such as clothes, electronics and food. amazon also makes there own thechnology such as kindle book readers and tablets or the alexa which is an inteligent ai. and they also have a streaming service which is called prime video.