Managers with at Least 5 Direct Reports | Leetcode 570 | Crack SQL Interviews in 50 Qs

[@learnwithchirag]

Hey there! 👋 For more interesting content, tutorials, and updates, Feel free to connect with me on Instagram Handles :- @createwithchirag - instagram.com/createwithchirag/ @learn.with.chirag - instagram.com/learn.with.chirag/ LinkedIn: www.linkedin.com/in/chirag-sehgal-9200111b8/ Let's stay connected and keep the creativity flowing! 💡

[@kaustubhrajput8199]

using sub query : select name from Employee where id in ( select distinct(managerId) from Employee group by managerId having count(managerId) >= 5)

[@learnwithchirag]

Yes , it can be done with this approach too ! Good work💯

[@user-fw4kz3bb4g]

bohot sahi samjhaya h bhai, you deserve way more subs

[@TalhaxD.]

Try Select * name from Employee where name = "John" Your 5 testcases will be passed 😁 Thankyou for Great Solution

[@akshanshsharma7415]

IT SHOULD BE -> SELECT name from Employee where name = "John"

[@TalhaxD.]

@@akshanshsharma7415 yess, typing mistake

[@nihalnandannayak8869]

# Code-1 select Employee.name from Employee where id IN (select e2.managerId from Employee e1 join Employee e2 using(id) group by e2.managerId having count(e2.managerId) >= 5) # Code-2(Without join) select Employee.name from Employee where id IN (select e2.managerId from Employee e2 group by e2.managerId having count(e2.managerId) >= 5)

[@aarzoo2302]

good explaination

[@learnwithchirag]

Glad it was helpful :)

[@maddycoder1294]

nice

[@learnwithchirag]

Thanks. Keep Learning 💯

[@jahnavibhatt4657]

Superb👌

[@learnwithchirag]

Glad you liked it ! Keep Learning 💯

[@apoorvpradhan5125]

Thank you bhaiya.

[@learnwithchirag]

Glad the content is helpful for you...Do share with your friends too 💯💐

[@apoorvpradhan5125]

@@learnwithchirag Yess ! All my friends are now taking help of your videos only 😃

[@pulkitjain5326]

Probably, the best explanations with ease on KZbin..🙌