Computers and Technology: 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

What is the SQL command to list the total sales

Ответ:

gwendallinesikes

14.08.2021

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".

What is the SQL command to list the total sales by customer and by product, with subtotals by custom

0,0(0 оценок)

Ответ:

melissacornut

09.11.2022

Computers and Technology

If (a+b)/(a-b)=c, then (a-b)/(a+b)=1/c
(2a-2b)/(5a+5b)=2(a-b)/5(a+b)=2/5 *1/c=2/(5c)

0,0(0 оценок)

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

Ответ:

Ответ:

Ask your question to the AI advisor

More tips

Answers on questions: Computers and Technology

Ask an AI advisor a question