Loading…
The merchandising team wants the two best-selling products in every category.
line_total in order_items. Return category, product_name, revenue (rounded to 2 decimals), and category_rank (1 or 2). If two products tie, the one whose name comes first alphabetically ranks higher. Order by category, then category_rank.Create a free account to save your progress and reveal the worked answer for this free exercise. The complete practice library is available with Practice Pass or Mastery.