Species Spending, Shift by Shift

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.
Write Your Query