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(hacker_id,' ', name) as xyz from (
Select Q.hacker_id , H.name from Hackers as H
left join (Select s.hacker_id,s.score from
Difficulty as d
left join Submissions as s
on d.score = s.score)Q
on H.hacker_id = Q.hacker_id
group by hacker_id , name
having count() > 1
order by count() DESC , hacker_id) t
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 →
what is the issue with my code?
Select Concat(hacker_id,' ', name) as xyz from ( Select Q.hacker_id , H.name from Hackers as H left join (Select s.hacker_id,s.score from Difficulty as d left join Submissions as s on d.score = s.score)Q on H.hacker_id = Q.hacker_id group by hacker_id , name having count() > 1 order by count() DESC , hacker_id) t