관리 메뉴
목록2024/12/18 (1)
rubus0304 님의 블로그
[코트카타 105]
Customers Who Bought All Products (오답) 5,6 product_key를 다 산 customer_id ㅠㅠ 왜 안 나오지.select customer_idfrom customer_id in (select c.customer_id from customer c join product_key p on c.product_key = p.product_key where p.product_key = 5 or 6) a (정답)select customer_idfrom customergroup by 1having count(distinct product_key) = (sele..
Data Analyst/daily
2024. 12. 18. 10:06