In this MySQL challenge, your query should return the information for the employee with the third highest salary. Write a query that will find this employee and return that row, but then replace the DivisionID column with the corresponding DivisionName from the table cb_companydivisions. You should also replace the ManagerID column with the ManagerName if the ID exists in the table and is not NULL.
SELECT DISTINCT salary
FROM maintable_1YA0N E WHERE
3 =(SELECT COUNT(DISTINCT salary)
FROM maintable_1YA0N WHERE E.salary <= salary)