Hackerrank SQL Solutions | Top Competitors SQL Hackerrank Medium Problem

In this video I am solving "Top Competitors" Problem on Hackerrank. This is a Medium SQL Problem.
____________________________________________
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

[@shafniiqbal1601]

Good work mate! loved the way you approached the problem, and how you broke it down into bits and worked your way towards the answer required.

[@thecodingmentor7701]

Thanks! Im glad you liked it

[@geofreykweyu6902]

great work mate.

[@keshav1530]

Great job, your thought process is amazing. It helped me not only in the solution but the approach as well that goes into these types of problems.

[@keshav1530]

Just one thing, Why "greater than 1 condition" is supposed to be in the HAVING clause and not in WHERE clause?

[@mohammadalamin7180]

really awesome solution !

[@dheerajgoyal7362]

Man you had it but still struggled for small stuff 😂 but yeah great way to approach a problem

[@thecodingmentor7701]

Thanks! Yes these small details can be tedious!

[@swarupsarangi734]

really liked your approach.. keep going !!

[@thecodingmentor7701]

Thanks Swarup. Would you like more Hackerrank SQL content or something else?

[@bhooshan25]

great explaination

[@mohanamaity3460]

why can't we join difficult and submission table on the score column

[@Kiruthikapari]

Could you please tell me why we having WHERE s.score = d.score

[@Lalit_Sharma_20]

while joining with challenges table, why didn't we joined them based on both columns challenge_id and hacker_id ?

[@thecodingmentor7701]

Hi Lalit, we didn't join the challenges table based on the column hacker_id because the hacker_id in the challenges table only tells you what hacker created that challenge. This information is not helpful in creating the desired output

[@sopandeole7]

Can you please tell me why did you use LEFT JOIN instead of JOIN?

[@thecodingmentor7701]

Hi Sopan, that's a good point, you don't have to use LEFT JOIN in this problem. JOIN works also fine!

[@Kiruthikapari]

Could you please clarify why we having " WHERE s.score = d.score " in where condition

[@abhijeetbhati1000]

because if you read explanation carefully you will notice that hackers who have obtained full marks are written
Difficulty table contains full score of Difficulty
and submissons score column contains score obtained by hacker
so we need hackers that obtained full score only

[@diftq8191]

This was medium level??

[@thecodingmentor7701]

Yes, some of them are quite tricky, even if its just medium