6. 게임을 10개 이상 발매한 퍼블리셔 찾기
2024-12-19
select
c.name
from
games g
inner join companies c on c.company_id = g.publisher_id
group by c.company_id
having count(c.company_id) >= 10
select
c.name
from
games g
inner join companies c on c.company_id = g.publisher_id
group by c.company_id
having count(c.company_id) >= 10