Top Competitor SQL HackerRank Challenge - Solved with Joins and Sub-queries
ฝัง
- เผยแพร่เมื่อ 3 ต.ค. 2024
- In this interesting challenge we would write an SQL query to determine top maximum earnings of a list of employees.
Link to Challenge - www.hackerrank...
Similar Challenges
✔️Top Earners SQL Challenge - • Top Earners SQL (Find ...
✔️Binary Tree in SQL - • Binary Tree Nodes SQL ...
Simple SQL Beginner Tutorials and Hands-On
👉 How to Write Stored Procedures - • How to Write Stored Pr...
👉 How to Setup MS SQL - • How to Create MS SQL D...
👉 Learn practical SQL here - • Practical SQL for Begi...
👉 SQL Tutorials here www.kindsonthegenius.com/mssql
👉 Pivoting in SQL - • How to Perform Pivotin...
🔥 Data Science Tutorial for Beginners
www.kindsonthe...
www.datarmatic...
www.munonye.com
www.datarmatics...
Solution to 30 Days HackerRank Coding Challenge here - bit.ly/38cWPyJ
My Free Python Programming Tutorial - www.kindsontheg...
My websites
All Tutorials - www.kindsontheg...
SpringBoot/Angular - www.munonye.com
Data Science Stuff - www.datarmatics...
Please join us at International Computer Programmers here:
👉 / 1447709731988533
Feel free to connect with me
❤️ Kindson on Instagram: / kindsonthegius
❤️ Kindson on LinkedIn: / kindson
❤️ Me on Quora: www.quora.com/...
❤️ Kindson on Twitter: / kindsonm
❤️ Kindson on Facebook: / kindsonm
Your support can help me improve my content:
✅ Buy me a coffee: www.buymeacoff...
SQL (Structured Query Language) is very useful for programmers, developers, data scientists and students
I am looking for this ...Thankyou
Most welcome 😊
good explanation, thank you
Why did you select the hacker id from submissions?
Also, why did you join the the submission table to the hackers table as opposed to joining the hackers to the challenge table?
Kindly explain
The submissions table contains the hacker_id and the MATCHING score for that record. So it's this is the best approach. A different approach could be possible but would not be optimal and you may not get the full points.
Thank you @@KindsonTheTechPro . I also noticed in some other solutions that people aggregated by the challenge id but you used the backer id.
@@mercystrings That's correct. There are more than one ways to extract the same results.
why do you have to join the submissions table and challenges table? can we just join the submissions table and difficulty table based on the score to get the id whose having maximum score?
use some quality mic or speak near to mic. the audio is very bad we are not able to listen clearly.
This is noted.