The Bronze Revenue Medalists
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
totalrevenue
thirdhighestrevenue

51. The Bronze Revenue Medalists

Identify the third highest revenue-generating customer within each species.

The merchants guild wants to identify the third highest total revenue generated by any customer within each species. Write a query to display the third highest revenue per species.
Write Your Query