This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Regional Warehouse Director at Amazon Logistics. Leadership wants a ranked view of warehouses by total order item revenue to prioritize capital investments. Revenue is calculated as quantity * unit_price from order items, summed across all orders fulfilled by each warehouse. Rank the warehouses from highest to lowest revenue using RANK().
You are a Regional Warehouse Director at Amazon Logistics. Leadership wants a ranked view of warehouses by total order item revenue to prioritize capital investments. Revenue is calculated as quantity * unit_price from order items, summed across all orders fulfilled by each warehouse. Rank the warehouses from highest to lowest revenue using RANK().