Use HR database (Sample tables and data are in DatabaseHR.pdf file). Write a query to show employee id, last name, first
Posted: Mon Jul 11, 2022 9:50 am
Use HR database (Sample tables and data are in DatabaseHR.pdffile). Write a query to show employee id, last name, first name ofall the employees, their managers, and the managers of theirmanagers.
You need to include the following columns in your result: EMPLOYEE_ID EmployeeLastName FirstLevelManagerFirstName SecondLevelManagerID SecondLevelManagerLastName EmployeeFirstName FirstLevelManagerID FirstLevelManagerLastName SecondLevelManagerFirstName ThirdLevelManagerID
You need to include the following columns in your result: EMPLOYEE_ID EmployeeLastName FirstLevelManagerFirstName SecondLevelManagerID SecondLevelManagerLastName EmployeeFirstName FirstLevelManagerID FirstLevelManagerLastName SecondLevelManagerFirstName ThirdLevelManagerID