[SQL문제풀기] 게임 개발사의 주력 플랫폼 찾기

문제

solvesql.com

https://solvesql.com/problems/main-platform-of-game-developers/

SQLite

내가 작성한 정답

with sales as (select c.name developer,p.name platform,
											sum(g.sales_na+g.sales_eu+g.sales_jp+sales_other) sales
              from games g
              join companies c on c.company_id = g.developer_id
              join platforms p on p.platform_id = g.platform_id
              group by c.name,p.name)

select developer, platform, sales
from sales
where (developer,sales) in (select developer, max(sales) from sales group by developer)