Customer Spending, Averaged and Analyzed
Tables Used
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
customerid
orderid
totalamount
averageordervalue

5. Customer Spending, Averaged and Analyzed

Compare every order to the customer's average; no hyperspace math required.

Xorthax wants to understand the spending habits of his intergalactic customers. Calculate the average order value for each Customer ID at his trading post on Zlacksys 19. Include each individual order's ID and total amount value.
Write Your Query