Species-Based Order Tiers
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
orderid
totalamount
spendingtier

38. Species-Based Order Tiers

Rank orders into 4 spending groups within each species.

Xorthax wants to categorize all orders into 4 spending tiers for each species. Write a query to rank orders by total amount within each species.
Write Your Query