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

what is the algebraic expressions of 8-6k​
Trail is 24.6km long. Hike .65 of the length. How many km has she hiked
13. A tow-truck applies a force of 2,000 N on a 2,000 kg car for a period of 3 seconds. What is the magnitude of the change in the car's momentum?
How did Waipuo in "Water Names" learn the tale she tells her granddaughters?​
Please help I will give you brainliest
Find the value of x.
Please help this is for a test, will give brainliest. Im pretty sure its B but I want to make sure A psychiatrist is seeing an elderly father and his daughter.
A wave is moving at the rate of 40 cm/s. Its wavelength is 5 cm. What is the frequency of the wave? INCLUDE THE CORRECT UNIT!
Tiffany earns an annual income of $55,000. After she pays taxes, her take home pay is $41,800. What percentage of her annual income does Tiffany pay in taxes?
help me fast fast 10 and 11​