In each category find the product that brought the most revenue from delivered orders: the category name, the product name, the revenue (sum of quantity × unit_price).
Tables · Online store
categoriesProduct categories8 rows
productsProducts63 rows
reviewsReviews330 rows
customersCustomers160 rows
ordersOrders640 rows
order_itemsOrder lines1,174 rows
Sign in to open this section
Sign in to solve problems and play the arena. It takes less than a minute.