윈도우 함수를 이용해서 풀고 싶어서 써봤습니다. 더 간단하게 줄일 수 있을까요?

Select Distinct s.hackers, h.name, s.final

From (

Select hackers, sum(maxscore) over (partition by hackers) as final

From

(

Select Distinct hacker_id as hackers, challenge_id,

max(score) over (partition by hacker_id, challenge_id) as maxscore

From Submissions

) sub

) s

Inner join Hackers h on h.hacker_id = s.hackers

Where s.final > 0

Order by s.final desc