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

문제

solvesql.com

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

SQLite

내가 작성한 정답

with a as (select developer_id, platform_id, sum(sales_na+sales_eu+sales_jp+sales_other) sales
            from games g
            group by developer_id, platform_id)

select c.name developer, p.name platform, max(sales) sales
from a a
join platforms p on a.platform_id = p.platform_id
join companies c on a.developer_id = c.company_id
where (a.developer_id,sales) in (select developer_id,max(sales) from a group by developer_id)
group by c.name, p.name