Привет работяги, в чем у меня ошибка ?
Условие
WITH cte1 AS (
SELECT
o.client_id,
SUM(p.price) AS sm,
o.id AS order_id
FROM product AS p
JOIN "order" AS o on p.order_id = o.id
WHERE o.client_id IN (
SELECT
ord.client_id
FROM "order" AS ord
WHERE ord.id IN (
SELECT
oo.id
FROM product AS pp
JOIN "order" AS oo ON pp.order_id = oo.id
GROUP BY oo.client_id, oo.id
HAVING SUM(pp.price) > 1000
)
GROUP BY ord.client_id
HAVING COUNT(*) >= 2
)
GROUP by o.client_id, o.id
)
SELECT
c.client_id AS id,
AVG(c.sm) AS avg_order
FROM cte1 AS c
GROUP BY c.client_id
ORDER BY c.client_id
