Search for question
Question

(10 points)

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