56. Species Spending, Shift by Shift
Show each customer's total order amount and that of the next same-species customer.
Xorthax wants to analyze spending patterns across different species. Write a query to display each customer's total order amount and the total order amount of the next customer from the same species, based on order date.
Explanation: