Solving LeetCode Interview SQL Question with Detailed Explanation | Practice SQL | LeetCode 181

Previous Video: LeetCode 175 Combining Two Tables

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 employees who earn more than their managers and also includes points to keep in mind to develop SQL queries. You will also learn about SELF 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

[MsFarman]

All I can say now is, you seem like an angel! I was wondering where to start, and how to start, and your videos came as a boon. Thank you!

[bananaboydan]

These are the greatest SQL videos I have ever come across. Thank you so much sir

[k_abhishek]

This question is little tricky but u explained very well. One suggestion please use marker to explain such kind of question .

[Ilovefriendswebseries]

forever the best channel to learn SQL and intricacies involved while answering interview questions ❤

[milindpatle]

Please create a video covering the most recent questions that are asked in product-based company interviews.

[akritisingh]

This style of explaining things is perfect. Because I can learn a new concept and see it's application at the same time. Very nice explanation ✨

[ayushmishra-fjhw]

very well explained please make more videos as u r explaining the concepts very nicely, please make more playlists on Datascience .
Thanks

[darshanapawar]

your explanation is really amazing !!☺

[mahmoudgad]

thanks you so much about your efforts in clearing the concepts and learning us by detailed practice

[messi_codes]

it would be good if you put problem link in description

[sammanluitel]

Can you please explain on and where clause in this .why you did e1. Managerid=e2.id and not the vice versa also in where clause how e1. Salary is referring to employee and e2. Salary to manager it's not clear. Please explain

[kunalmane-plvx]

It would be more helpful if u show output of inner join and left join on board.. otherwise well explained

[AbhishekSingh-vldp]

thanks alot for this series, very helpful !!

[abhilashs]

reached little late but really helpful

[anonymous-zefg]

This is very helpful, Thank you, sir.

[yagniktalaviya]

Hey there, I know basic DBMS concepts, should i start practicing SQL queries with this playlist???

[lynju_]

my brain made this way harder than its suppose to be...

[gagansingh]

Cab we get the link so we directly land to the page & practice sir

[LEVI-hvdw]

Select name as employee from employee where manager I'd < 4 ;
I wrote this and no error wass
And i didn't understand anything I guess I am a fool 😃

[PawanSingh-jxnu]

CREATE TABLE Employees (
id int PRIMARY KEY,
name varchar(50),
salary int,
managerid int
);

INSERT INTO Employees (id, name, salary, managerid)
VALUES (1, 'JOe', 70000, 3), (2, 'Henery', 8000, 4), (3, 'Sam', 60000, null), (4, 'Max', 90000, null);