Species Spending Standings
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
rank

24. Species Spending Standings

Rank customers within their species by how much they spent on Xorthax's wares.

Xorthax is ranking his customers based on their total spending in the galaxy. Rank customers within their respective species based on their total spending at his trading post.
Write Your Query