Mrcastaway5257 Mrcastaway5257
  • 15-07-2021
  • Computers and Technology
contestada

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

Respuesta :

codiepienagoya codiepienagoya
  • 19-07-2021

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
Answer Link

Otras preguntas

-(-4f+5) Wouldn't it be -4f- (-5)
A pair of vertical angles have measures (2z+43)° and (−10z+25)° . What is the value of z?
what was Antonio gramsci imprisoned for?
What is 874 divided by 7 help plz
I need Help on number 23
What important responsibility did the Second Continental Congress take on in May 1775?
what is three yards two feet and one inch minus one yard two feet and three inches?
How do the main characters actions affect others in to kill a mockingbird?
How can you tell the difference between a square and a rhombus? Thanks!
If you are looking for an insulator you are looking for a material that will allow the flow of electrons. inhibit the flow of neutrons. allow the flow of pro