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.
Compute each product's total revenue (price times summed quantity) and assign a 'revenue_rank' with RANK ordered by revenue descending. Return product 'name', 'revenue', and 'revenue_rank' ordered by 'revenue_rank'.