7. Species Spending Champions
Find customers whose average revenue matches the top spenders of their species.
Xorthax wants to identify the top spenders within each species group at his trading post. Write a query to calculate each customer's average revenue and return only those customers whose average revenue matches the highest in their species.
Explanation: