Cumulative Spending by Species
Tables Used
customers
ColumnType
customeridbigint
nametext
speciestext
contactinfotext
loyaltystatustext
joindatetext
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
species
customerid
totalspending
spendingdistribution

65. Cumulative Spending by Species

Show each customer's cumulative distribution of total spending within their species.

Xorthax wants to analyze cumulative spending distribution by species. Write a query to calculate the cumulative distribution of total spending for each customer within their species.
Write Your Query