How will you find out the superior for an employee whose emp_id is 3

You can use a self-join to find the manager of an employee whose emp_id is 3

Select e.emp_id,e.emp_name, title

Fromemployee e, employee s

where e.superior_emp_id = s.employee_idand e.emp_id = 3

This should return: 1, Peter, CIO