Multi Join SQL Problem | Employee & Manager with same number of reportee | SQL Problem Solving

In this SQL problem solving session, we work to find out the employees who have same number of people reporting to them as to their managers.

Table creation & insertion script:
CREATE TABLE emp_info(
emp_id INT,
emp_name VARCHAR(200),
emp_location VARCHAR(100),
emp_gender CHAR(1),
emp_mgr_id INT
);

INSERT INTO emp_info VALUES(21,'Rupali','Pune','F',12),
(61,'Sneha','Delhi','F',33),
(83,'Vikas','Delhi','M',33),
(78,'Rahul','Bengaluru','M',12),
(45,'Gargi','Nagpur','F',21),
(12,'Sachin','Pune','M',null),
(67,'Yashwant','Jaipur','M',78),
(79,'Yogesh','Satara','F',67),
(33,'Vijay','Nashik','M',21);

#sql #sqlprogramming #sqlqueries #interview

Видео Multi Join SQL Problem | Employee & Manager with same number of reportee | SQL Problem Solving канала Rahul Upadhyay