with cte as(
select hackers.hacker_id as id,hackers.name as name,submissions.challenge_id as ch_id ,submissions.score as score,
row_number() over (partition by hackers.hacker_id,submissions.challenge_id order by submissions.score desc) as rn from hackers
inner join submissions
on hackers.hacker_id=submissions.hacker_id
)
select cte.id,cte.name,sum(cte.score) as sm from cte
where cte.rn=1
group by cte.name,cte.id
having sum(cte.score)>1
order by sm desc,cte.id asc;

with cte1 as (
select h.hacker_id as hacker_id, 
    h.name as name, 
    s.score as score, 
    s.challenge_id as challenge_id,
    row_number() over (partition by hacker_id, challenge_id order by score) as rn
from hackers h 
join submissions s
on h.hacker_id = s.hacker_id
-- group by h.hacker_id, h.name
)

select hacker_id, name, sum(score) as total_score
from cte1
where rn=1
group by hacker_id, name
having sum(score) > 0 
order by total_score desc, hacker_id ASC

select h.hacker_id,h.name,sum(s.score)
from hackers h join Submissions s on h.hacker_id=s.hacker_id 
where 
score in (select max(score) from Submissions group by hacker_id,challenge_id)
group by h.hacker_id,h.name,s.challenge_id
having sum(s.score)>0
order by sum(s.score) desc, h.hacker_id asc``