WAQ to find out the EMP NAME, MANAGER,SENIOR MANAGER FROM EMPLOYEE TABLE

 --#15day SQL CHALLENGE
--DAY 4
---Follow my blog to get the question & answer asked by a  company.

----Write a SQL Query to find out the EMP NAME, MANAGER,SENIOR MANAGER FROM EMPLOYEE TABLE

SELECT REPLICATE('*',400) as 'Sample_Table_Created'

create table emp_tbl(

emp_id int,

emp_name varchar(20),

department_id int,

salary int,

manager_id int,

emp_age int);

insert into emp_tbl

values

(1, 'Ankit', 100,10000, 4, 39);

insert into emp_tbl

values (2, 'Mohit', 100, 15000, 5, 48);

insert into emp_tbl

values (3, 'Vikas', 100, 12000,4,37);

insert into emp_tbl

values (4, 'Rohit', 100, 14000, 2, 16);

insert into emp_tbl

values (5, 'Mudit', 200, 20000, 6,55);

insert into emp_tbl

values (6, 'Agam', 200, 12000,2, 14);

insert into emp_tbl

values (7, 'Sanjay', 200, 9000, 2,13);

insert into emp_tbl

values (8, 'Ashish', 200,5000,2,12);

insert into emp_tbl

values (9, 'Mukesh',300,6000,6,51);

insert into emp_tbl

values (10, 'Rakesh',500,7000,6,50);

SELECT * FROM emp_tbl

---------------------------------------START SOLUTION------------------------

SELECT REPLICATE('*',400) Solution

SELECT   E.emp_id,E.emp_name AS 'EMP NAME',M.emp_name AS 'Manager Name' ,SM.emp_name AS 'Senior Manager'   FROM emp_tbl E
 JOIN emp_tbl M ON E.manager_id=M.emp_id
 JOIN emp_tbl SM ON M.manager_id=SM.emp_id

 SELECT REPLICATE('*',400) as  'End of Solution'

 -------------------------------------END OF SOLUTION--------------------------