[SQL문제풀기] 게임을 10개 이상 발매한 게임 배급사 찾기

문제

solvesql.com

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

SQLite

내가 작성한 정답

select c.name
from companies c
join games g on c.company_id= g.publisher_id
group by g.publisher_id
having count(game_id) >= 10;