We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Select
CONCAT(ss.hacker_id," ",h.name)
from (
Select s.hacker_id,
sum(case when s.score = d.score then 1 else 0 end ) as Full_score_Challenges_count
from Submissions s
left join challenges c on s.challenge_id = c.challenge_id
left join difficulty d on c.difficulty_level = d.difficulty_level
group by 1
having Full_score_Challenges_count >1
) ss
join hackers h
where ss.hacker_id = h.hacker_id
order by ss.Full_score_Challenges_count Desc, ss.hacker_id;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Top Competitors
You are viewing a single comment's thread. Return to all comments →
My SQL: