- Basic Join > group by + subqueries
https://www.hackerrank.com/challenges/contest-leaderboard/problem?isFullScreen=true
select h.hacker_id
,h.name
,sum(s.score)
from hackers h
inner join (
select hacker_id
,challenge_id
,max(score) score
from submissions
group by hacker_id, challenge_id
having max(score) > 0
) s
on h.hacker_id = s.hacker_id
group by h.hacker_id, h.name
order by sum(score) desc, h.hacker_id asc;
yozzum
The HR Contest Leaderboard showcases the prowess of human resource professionals navigating a landscape of challenges. As contenders vie for the top spot, strategic prowess in crafting compelling interview questions and answers becomes the linchpin. The competition is a melting pot of innovation and expertise, where participants demonstrate their ability to select, frame, and respond to queries that unravel the core of candidate potential.