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

[@MsFarman96]

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!

[@bananaboydan3642]

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

[@EverydayDataScience]

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

[@Ilovefriendswebseries]

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

[@k_abhishek2056]

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

[@akritisingh7758]

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 ✨

[@EverydayDataScience]

Glad that you are finding the videos useful, Akriti.

[@darshanapawar399]

your explanation is really amazing !!☺

[@EverydayDataScience]

Glad that you found the video helpful 😊

[@Music-tp8gg]

BRo so clear explanation

[@milindpatle1784]

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

[@sammanluitel3018]

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

[@vaishalibaderia3846]

Yeah same question

[@deadman6236]

It should be opposite e1.id = e2.managerid Because in where condition manager is is suppose to be lesser than employee of which is asked in question

[@AbhishekSingh-vl1dp]

thanks alot for this series, very helpful !!

[@messi_codes]

it would be good if you put problem link in description

[@EverydayDataScience]

Yes, Suditya, I got the suggestion from another person as well and I have started doing it , so all the later videos have the link in the description.

[@mahmoudgad8466]

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

[@EverydayDataScience]

Glad that you are finding the videos helpful😊

[@ayushmishra-fj3hw]

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

[@EverydayDataScience]

Glad that you are finding the videos useful 😊 Definitely, more videos will keep coming.

[@messi_codes]

thanks for this awesome playlist

[@EverydayDataScience]

Glad that you are finding the videos useful.

[@anonymous-ze5fg]

This is very helpful, Thank you, sir.

[@EverydayDataScience]

Glad that you found it useful 😊

[@saibabatelagamsetty2538]

Very Great explanation.

[@EverydayDataScience]

Glad that you found the video useful.

[@kunalmane-pl8vx]

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

[@abhilashs1345]

reached little late but really helpful

[@EverydayDataScience]

Glad that you are liking the videos.

[@mydataarena]

good work

[@EverydayDataScience]

Glad that you found it useful 😊

[@yagniktalaviya2146]

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

[@swethag-ms6vt]

Can you solve coderbyte sql questions

[@svanaja331]

nice

[@EverydayDataScience]

Glad that you found it useful.

[@lynju_]

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

[@EverydayDataScience]

Hopefully this video was helpful to clear any doubts regarding the same.

[@er.priteshkumar6363]

👍

[@snehajajodia75]

❤

[@gagansingh3481]

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

[@EverydayDataScience]

I have started putting down the links in the description after few initial videos.

[@LEVI-hv8dw]

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

[@PawanSingh-jx8nu]

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);

[@pragatiaggarwal8103]

thanks