LeetCode Interview SQL Question with Detailed Explanation | Practice SQL | LeetCode 577

Previous Video: LeetCode 603 Consecutive Available Seats
• LeetCode Interview SQL...
In this video I solve and explain a leetcode SQL question using MySQL query. This question has been asked in Apple, Facebook, Amazon, Google, Adobe, Microsoft, Adobe interviews or what we popularly call FAANG interviews.
I explain the related concept as well. This question is about finding employee bonus and also includes points to keep in mind to develop SQL queries. You will also learn about LEFT JOIN.
LeetCode is the best platform to help you enhance your skills, expand your knowledge and prepare for technical interviews.
If you found this helpful, Like and Subscribe to the channel for more content.
#LeetCodeSQL #FAANG #SQLinterviewQuestions

[@slater-cguy]

Great content: clear explanations and great tips/strategies for writing better SQL. I try to solve the problems on leetcode before watching, the learning is better after some struggle!

[@er.priteshkumar6363]

👍

[@muhammadusman3265]

amazing content

[@EverydayDataScience]

Glad that you are finding the videos useful. Thanks for such kind words 😊

[@MyAnish22]

In previous examples you mentioned that if we do Left Join instead of Inner Join it takes care of NULL. Meaning it will select every row from left table and have the values NULL. The only difference in previous example was the Foreign Key was different from Primary table. Bit confused here why we wrote b.bonus IS NULL as for two employees the empld was not present in bonus table

[@LEVI-hv8dw]

All these questions are premium questions

[@EverydayDataScience]

Yes, most of the Leetcode questions are premium. That’s why I go through the question completely line by line along with the examples.

[@LEVI-hv8dw]

@@EverydayDataScience then what should I do now......cuz I was trying to prepare for interviews and i have only 4 months left for my btech to complete

[@abhinavtiwari6186]

Why we are using left join here... can't we do it simply with natural join?

[@Niyander9]

Natural join will give employees present in both tables.