Доля логистики в выручке по каналам за последний квартал
SQL, по которому посчитано
WITH channel_metrics AS (
SELECT
channel,
SUM(revenue - returned_revenue) AS net_revenue,
SUM(logistics) AS logistics_cost
FROM sales
WHERE date >= (
SELECT date_trunc('quarter', MAX(date))
FROM sales
)
GROUP BY channel
)
SELECT
channel,
round(net_revenue, 2) AS net_revenue_rub,
round(logistics_cost, 2) AS logistics_rub,
round(logistics_cost / NULLIF(net_revenue, 0), 4) AS logistics_share
FROM channel_metrics
ORDER BY logistics_share DESC
LIMIT 30