Комиссия маркетплейса на единицу по артикулам за последний месяц
SQL, по которому посчитано
WITH last_month AS (SELECT date_trunc('month', max(date)) AS month_start FROM sales), base AS (SELECT s.channel, s.sku, s.product, s.units, s.commission FROM sales s CROSS JOIN last_month lm WHERE s.date >= lm.month_start AND s.date < lm.month_start + INTERVAL '1 month' AND s.channel <> 'Сайт' AND s.commission > 0), agg AS (SELECT channel, sku, max(product) AS product, SUM(units) AS units, SUM(commission) AS commission, ROUND(SUM(commission) / NULLIF(SUM(units), 0), 2) AS commission_per_unit FROM base GROUP BY channel, sku) SELECT sku || ' / ' || channel AS sku_channel, sku, product, channel, units, ROUND(commission, 2) AS commission, commission_per_unit FROM agg WHERE units > 0 ORDER BY commission_per_unit DESC LIMIT 30