I'm not sure what the issue is in my statement. Please help!

The Employee table has the following columns: - ID - integer, primary key - FirstName - variable-length string - LastName - variable-length string - Managerid - 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. 455292.3057586.03z9y7 \begin{tabular}{|l|l} LAB ACTIVITY & 4.9.1: LAB - Select employees and managers with inner join \\ & \\ 1 & SELECT A. FirstName AS 'Employee', B.FirstName AS 'Manager', \\ 2 & FROM Employee A, \\ 3 & INNER JOIN Employee B, \\ 4 & ORDER BY A. FirstName ASC; \end{tabular} Query failed: ERROR 1064 (42000) at line 1: You have an error in your sQL syntax; check the INNER JOIN Employee B, ORDER BY A.FirstName ASC' at line 2 2:Result set test Query failed: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the INNER JOIN Employee B, ORDER BY A.FirstName ASC' at line 2