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

문제

solvesql.com

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

SQLite

내가 작성한 정답

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