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.
SQL SERVER :
with CTE as (
select h.hacker_id ,h.name,count(c.challenge_id) as ChallengesCreated from Hackers h
join Challenges c
on h.hacker_id=c.hacker_id
group by h.hacker_id,h.name
),
b1 as(
select hacker_id,name,ChallengesCreated,count(ChallengesCreated) over(partition by ChallengesCreated) rnk , max(ChallengesCreated) over () MaxChallenge from CTE)
select hacker_id,name,ChallengesCreated
from b1
where
ChallengesCreated not in (select ChallengesCreated from b1 where
rnk>1 and ChallengesCreated
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
SQL SERVER : with CTE as ( select h.hacker_id ,h.name,count(c.challenge_id) as ChallengesCreated from Hackers h join Challenges c on h.hacker_id=c.hacker_id group by h.hacker_id,h.name ), b1 as( select hacker_id,name,ChallengesCreated,count(ChallengesCreated) over(partition by ChallengesCreated) rnk , max(ChallengesCreated) over () MaxChallenge from CTE)
select hacker_id,name,ChallengesCreated from b1 where ChallengesCreated not in (select ChallengesCreated from b1 where rnk>1 and ChallengesCreated