- Basic Join > group by + subqueries
https://www.hackerrank.com/challenges/contest-leaderboard/problem?isFullScreen=true
select h.hacker_id, h.name, sum(t.mx) total
from hackers h
inner join (select hacker_id hid, challenge_id cid, max(score) mx
from submissions
group by hacker_id, challenge_id) t
on h.hacker_id = t.hid
group by h.hacker_id, h.name
having total > 0
order by total 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.