SQL 이것저것

[solvesql] 우리 플랫폼에 정착한 판매자 1

agingcurve 2022. 7. 13. 20:08
반응형

SELECT SELLER_ID, COUNT(DISTINCT ORDER_ID) AS ORDERS
FROM OLIST_ORDER_ITEMS_DATASET
GROUP BY SELLER_ID
HAVING COUNT(DISTINCT ORDER_ID) >= 100;