1978. Employees Whose Manager Left the Company || Leetcode SQL solution || simple sql query || 🔥🔥🔥💯💯💯✅✅✅

 

Employees whose manages left their company : 👇👇👇💯 

Leetcode Solution:-- 

Intuition

To find the manager who left the company, whose salary is less than 30000 dollars

Approach

step 1: filter the rows whose salary is strictly less than $30000

select *
from employees
where salary <= 30000

 Here manager_id = 6 left the company (because it isn't in employee_id column)

step 2: we need to find the manager how left the company. This we can find by searching it in employee_id from employees table (with a sub query ).

select employee_id  
from employees 
where salary <= 30000 
and manager_id not in (select employee_id from employees)

step 3: we need to order the table by employee_id.

Code

# Write your MySQL query statement below
select employee_id  
from employees 
where salary <= 30000 and manager_id not in (select employee_id from employees)
order by employee_id;

Please go through my blog and find more solutions :- )) 

Happy Learning :-)