Respuesta :

Answer:

Please find the complete query and question in the attached file.

Explanation:

In this query, we use the select command in which we select the column that is "CUS_CODE, P_CODE" with the sum method that multiples the  "SALE_UNITS * SALE_PRICE" values and use them as and group by the clause that stores all the values in the column  that are "CUS_CODE, P_CODE WITH ROLLUP".

Ver imagen codiepienagoya
Ver imagen codiepienagoya