This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Merchandising Analyst at Walmart. The category management team wants to understand which product categories generate the most revenue so they can allocate shelf space and marketing budgets accordingly. Revenue for each line item is stored in the line_subtotal column in the order items table, and the product category is stored in the products table.
You are a Merchandising Analyst at Walmart. The category management team wants to understand which product categories generate the most revenue so they can allocate shelf space and marketing budgets accordingly. Revenue for each line item is stored in the line_subtotal column in the order items table, and the product category is stored in the products table.