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

Previous Video: LeetCode 603 Consecutive Available Seats

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

[LEVI-hvdw]

All these questions are premium questions

[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!

[muhammadusman]

amazing content <3 keep it up man huge appreciation

[MyAnish]

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

[abhinavtiwari]

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