Кампании без заказов по расходу за 12 месяцев
SQL, по которому посчитано
WITH ad_period AS (
SELECT
source,
campaign,
SUM(cost) AS cost,
SUM(clicks) AS clicks,
SUM(impressions) AS impressions,
SUM(orders) AS orders
FROM ads
WHERE date > (SELECT max(date) FROM sales) - INTERVAL 12 MONTH
GROUP BY source, campaign
HAVING SUM(cost) > 0 AND SUM(orders) = 0
)
SELECT
source || ' / ' || campaign AS campaign,
source,
round(cost, 2) AS cost,
clicks,
impressions
FROM ad_period
ORDER BY cost DESC
LIMIT 30