우리 플랫폼에 정착한 판매자 2 & 직속 상사 구하기 (solvesql)

우리 플랫폼에 정착한 판매자 2

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

SELECT
  seller_id,
  count(DISTINCT order_id) AS orders
FROM
  olist_order_items_dataset
WHERE
  price >= 50
GROUP BY
  seller_id
HAVING
  orders >= 100
ORDER BY
  orders DESC

직속 상사 구하기

https://solvesql.com/problems/find-manager/

이 문제는 자체 조인을 통해서 풀면 됩니다!

SELECT
  A.employee_id,
  A.name,
  A.manager_id,
  B.name AS manager_name
FROM
  employees A
  join employees B ON A.manager_id = B.employee_id
ORDER BY
  employee_id