Lab 3.83.8 LAB - Selectemployees andmanagers with innerjoinThe Employee table has the following columns:• ID - integer, primary key• FirstName - variable-length string• LastName -...

Extracted text: 11:33 ull 5GE 4 K All Inboxes Noeli komlan Yesterday To: Noeli komlan > Lab 3.8 3.8 LAB - Select employees and managers with inner join The Employee table has the following columns: • ID - integer, primary key • FirstName - variable-length string • LastName - variable-length string • ManagerID - integer /rite 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.