Programming Task 5
The Employee table has the following columns:
ID - integer, primary key
FirstName - variable-length string
LastName - variable-length string
• Manager ID - integer
•
•
Write a SELECT statement to show a list of all employees' first names and their managers' first
names. List only employees that have a manager. Order the results by Employee first name. Use
aliases to give the result columns distinctly different names, like "Employee" and "Manager".
Hint: Join the Employee table to itself using INNER JOIN.
(6 points)
Fig: 1