We use analytics and advertising cookies to understand how the site is used and whether our ads on Facebook and Instagram work. They are set only if you accept. See our Privacy Policy for details.
jan, feb, mar and apr (use 0 when the customer spent nothing that month). Return the customer name plus the four month columns, only for customers with at least one order, ordered by name. Use SUM over a CASE expression.