CTE с WITH
Содержание курса
0 / 1 баллов
Аналитик пишет запрос с двумя CTE:
WITH cte1 AS (
SELECT customer_id, COUNT(*) AS cnt FROM orders GROUP BY customer_id
),
cte2 AS (
SELECT customer_id FROM cte1 WHERE cnt > 1
)
SELECT name FROM customers JOIN cte2 ON customers.customer_id = cte2.customer_id;
Что из перечисленного верно?