The merchants guild of Zlacksys 19 wants to identify the species generating the most revenue for Xorthax. Write a query to rank species based on their total revenue at the trading post.