Species Revenue Surge
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
totalrevenue
revenuerank
revenuecumedist

71. Species Revenue Surge

Rank species by total revenue and track their cumulative revenue distribution.

Xorthax wants to track the top-performing species by total revenue and calculate the cumulative revenue percentage for each species. Write a query to rank species and calculate their cumulative revenue distribution.
Write Your Query