SQL | Find the employees from the employee table who are also managers ?

In this video we will find the employees from the employee table who are also mangers using SQL.

DDL and DML :

--Employee table

CREATE TABLE Employee (
EMPLOYEE_ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
FIRST_NAME CHAR(25),
LAST_NAME CHAR(25),
SALARY INT,
JOINING_DATE DATE,
DEPARTMENT CHAR(25),
MANAGER_ID INT
);

INSERT INTO Employee
(FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT,MANAGER_ID) VALUES
('James', 'Smith', 100000, '2020-02-02', 'HR', 002),
('Jessica', 'Kohl', 80000, '2011-06-17', 'Admin', 005),
('Alex', 'Garner', 300000, '2020-02-17', 'HR', 011),
('Pratik', 'Pandey', 500000, '2020-02-17', 'Admin', 020),
('Christine', 'Robinson', 500000, '2011-06-17', 'Admin', 007),
('Deepak', 'Gupta', 200000, '2011-06-17', 'Account', 015),
('Jennifer', 'Paul', 75000, '2020-01-17', 'Account', 012),
('Deepika', 'Sharma', 90000, '2011-04-17', 'Admin', 017);

@dataprojecthub
#dataprojecthub #data_project_hub #sqlqueries #sql_interview_queries