SQL 문제 풀이 챌린지(6/25) - 게임을 10개 이상 발매한 퍼블리셔 찾기

저작권 문제로 인해, 직접 작성한 쿼리문만 공개.

6. 게임을 10개 이상 발매한 퍼블리셔 찾기

https://solvesql.com/problems/publisher-with-many-games/

WITH publisher AS (
  SELECT
    publisher_id,
    COUNT(*) AS game_cnt
  FROM games
  GROUP BY publisher_id
  HAVING COUNT(*) >= 10
)

SELECT name
FROM companies
WHERE company_id IN (SELECT publisher_id FROM publisher)