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.
name and their total order amount as total_spent, showing 0 (not NULL) for customers who never ordered. Order by total_spent descending, then name ascending.