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 A.hacker_id, name
from
(select hacker_id, count(challenge_id) as num
from
(select A.challenge_id, A.hacker_id, submission_id, difficulty_level, target, B.score as obtained from
(select challenge_id, hacker_id, A.difficulty_level, score as target
from Challenges as A
inner join
Difficulty as B
on A.difficulty_level = B.difficulty_level) as A
inner join
Submissions as B
on A.challenge_id = B.challenge_id
where B.score = target) as A
group by hacker_id
having count( challenge_id)>1) as A
inner join
Hackers as B
on A.hacker_id = B.hacker_id
order by num desc, A.hacker_id asc
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 error in this? please help
select A.hacker_id, name from (select hacker_id, count(challenge_id) as num from (select A.challenge_id, A.hacker_id, submission_id, difficulty_level, target, B.score as obtained from (select challenge_id, hacker_id, A.difficulty_level, score as target from Challenges as A inner join Difficulty as B on A.difficulty_level = B.difficulty_level) as A inner join Submissions as B on A.challenge_id = B.challenge_id where B.score = target) as A group by hacker_id having count( challenge_id)>1) as A inner join Hackers as B on A.hacker_id = B.hacker_id order by num desc, A.hacker_id asc