LeetCode Medium 184 'Department Highest Salary' Amazon Interview SQL Question With Explanation

In this video I solve and explain a medium difficulty 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 includes points to keep in mind to develop SQL queries.

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

[dwaipayansaha]

Hi there!
I have two questions.
a) We could have used inner join too as in this question our subject of interest is highest salary per dept. So even if there are some people with dept name missing, it will not bea problem
b) We could have used the rank function also and select the rank 1 records, right

Please correct me if I am wrong.
Thanks,

[TuringTested]

Very simple very simple mat kiya karo, it depends on the level the person who is trying the question is, it demotivates people who are not able to solve if they are at beginner level. Bar bar very simple very simple bol rahe ho