Percent Rank: Species Spending Edition
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
percentrank

61. Percent Rank: Species Spending Edition

Calculate each customer's percent rank for spending within their species.

Xorthax wants to rank customers by their total spending within their species as a percentage. Write a query to calculate the percent rank for each customer based on their spending within their species.
Write Your Query