Leetcode 2324. Product Sales Analysis IV

Given product and sales tables, compute per-product aggregate metrics (like total revenue or units sold) and return products that meet a comparison or ranking condition (e.g., top sellers, below/above group average, or no recent sales). This typically requires SQL joins with GROUP BY/HAVING and often window functions to compare or rank results efficiently.