[SQL문제풀기] 우리 플랫폼에 정착한 판매자 2

silver

Feb 25, 2025

Contents

문제

solvesql.com

https://solvesql.com/problems/settled-sellers-2/

내가 작성한 오답

: 개별 상품이 50달러 이상이어야 한다.


select seller_id, count(order_id) orders
from olist_order_items_dataset
where order_id in (select order_id 
                    from olist_order_items_dataset 
                    group by order_id
                    having sum(price) >= 50)
group by seller_id 
having orders >= 100
order by 2 desc

내가 작성한 정답


select seller_id, count(distinct order_id) orders
from olist_order_items_dataset
where price >= 50
group by seller_id 
having orders >= 100
order by 2 desc