Hackerrank SQL Solutions | Contest Leaderboard SQL Hackerrank Medium Problem Subquery Version

This video is solving the "Contest Leaderboard" Problem on Hackerrank. This is a medium SQL Problem. In this version I am solving the problem with a Subquery. Here is a different solution including a with Statement: • Hackerrank SQL Solutio...
____________________________________________
SUBSCRIBE!
Do you want to understand how to solve SQL Problems in every detail? That's what my channel is about. When I was younger I thought I could never program because it looked way too difficult. The truth is that it takes time but with some patience anybody can do it! Follow me along and get better!
____________________________________________
SUPPORT MY CHANNEL
🙌The best way to support my channel right now is to give me a Super Thanks. You can do that by clicking thanks next to the title of the video. It is much appreciated!
____________________________________________
💾GitHub: github.com/CuriosityLeonardo?...
✋Add me on LinkedIn to get in contact: / markus-friemann-221b3814b

[@giadinhaustintx]

very helpful. Thanks.

[@rahulnegi2059]

Thank you. It was really helpful.

[@thecodingmentor7701]

Glad it was helpful!

[@Pr3kashSingh]

thanks

[@thecodingmentor7701]

You're welcome!

[@dharmaputra7394]

Thanks 👍

[@thecodingmentor7701]

No problem 👍

[@dharmaputra7394]

@@thecodingmentor7701 request how to solved problem to more about subquery

[@hanguyenhoang6297]

with a as (select
Submissions.hacker_id as hi, name, challenge_id, score, max(score) over(partition by Submissions.hacker_id, challenge_id) as mc
from Submissions join Hackers on Submissions.hacker_id = Hackers.hacker_id)
select hi,name,sum(score)
from a
where mc=score
group by hi, name
having sum(score) > 0
order by sum(score) desc, hi;
Hi, video is very helpful but i have another solution and result is exactly like butit is a wrong anwser and i dont know what i'am wrong, can you explain for me, thank you very much