Must be MySQL

A company maintains data on their employees in a table called employee. Write a query to find out the manager's name for each employee. The final result should contain employee_no, employee_name, manager_no, and manager_name. Note that manager_no is also an employee_no. The output should exclude employees with invalid managers. Input Format Column employee no employee name String department no Integer salary manager no Type Integer Integer Integer Sample Output employee_no employee_name manager_no manager_name 10001 10002 Colt A. Juarez 20001 Chloe Q. Walsh Damian B. Gay 20002 Addison Z. Thomas