Bangladesh Submarine Cables PLC
Post: Assistant Maintenance Engineer
Exam Date: 08/05/2026
1. See the following Table:
Employees(EMP_ID, EMP_Name, Manager_ID, Dept_ID);
Departments(Dept_ID, Salary, Dept_Name, Emp_ID);
1(a) Find out the names of manager of each employee.
SELECT e.EMP_Name AS Employee,
m.EMP_Name AS Manager
FROM Employees e
LEFT JOIN Employees m
ON e.Manager_ID = m.EMP_ID;
1 b) Sort the employees of each department based on salary in descending order
SELECT e.EMP_Name, d.Dept_Name, d.Salary
FROM Employees e
JOIN Departments d
ON e.EMP_ID = d.Emp_ID
ORDER BY d.Dept_ID, d.Salary DESC;