Xorthax wants to group his customers into 4 tiers based on their total spending at his trading post. Write a query to assign each customer to a spending tier within their species.