Genrate the SQL commands to create the following output: Lets use all the functi

Question

Genrate the SQL commands to create the following output:

Lets use all the functions we might see in daily or monthly order report. Generate the SQL commands to create the following table. Customer #000000001 1 9 158763.734444 28599.83 357345.46 Customer 000000002 2 10 115650.492000 37156.97 201568.55 Customer #000000004. 4. 31 133373.141613 6829.14 275581.07 Customer #0000000055 E 9 120449.193333 29999.18 271505.25 Customer#0000000077 24 163417.540833 34119.28 354885.81 Customer#000000008 8 14 165114.196429 57858.41 256717.52 Customer#0000000010 10 27 143151.784444 6751.5 322342.37 Customer #000000011 11 7 176212.361429 16873.08 302431.56 Customer #000000013 13 21 109182.598571 23620.23 304442.62 Customer #000000014 14 11 162487.189091 27393.03 248409.17 Column 3 is the total number of orders, column 4 is the average order value, column 5 is the minimum order value, and column 6 is maximum order value.

Explanation / Answer

Select 'Customer#' || customerNo, count(*), avg(quantity*price),min(quantity*price),max(quantity*price) from Orders group by customerNo;

|| is concatenation operator

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.