Выручка и выручка после возвратов по артикулам на Вайлдберриз
SQL, по которому посчитано
WITH wb AS (
SELECT
sku,
any_value(product) AS product,
sum(revenue) AS revenue,
sum(returned_revenue) AS returned_revenue,
sum(units) AS units,
sum(returned_units) AS returned_units
FROM sales
WHERE channel = 'Wildberries'
AND date > (SELECT max(date) FROM sales) - INTERVAL 12 MONTH
GROUP BY sku
)
SELECT
sku,
product,
round(revenue, 0) AS revenue,
round(returned_revenue, 0) AS returned_revenue,
round(revenue - returned_revenue, 0) AS revenue_after_returns,
units,
returned_units,
round(returned_revenue / nullif(revenue, 0), 3) AS return_share
FROM wb
ORDER BY revenue DESC
LIMIT 20