commit 3ad473ebfe0bfd76823d0feb0623d800261c16c1 parent daa86c00084ebec4cb2e9a1e76b2d854cf86eee5 Author: AndrewLockVI <andrewlaack1@gmail.com> Date: Sat, 8 Jul 2023 12:42:45 -0500 Completed employees whose managers left the company using MySQL Diffstat:
| A | employees-whose-manager-left-the-company/managers-who-left-the-company.sql | | | 11 | +++++++++++ |
1 file changed, 11 insertions(+), 0 deletions(-)
diff --git a/employees-whose-manager-left-the-company/managers-who-left-the-company.sql b/employees-whose-manager-left-the-company/managers-who-left-the-company.sql @@ -0,0 +1,11 @@ +--Given a table with employees and their managers +--return all employees who have a manager that does not +--have an associated record. + +SELECT Employees.employee_id +FROM Employees +LEFT JOIN Employees AS E +ON Employees.manager_id = E.employee_id +WHERE Employees.salary < 30000 +AND (E.employee_id IS NULL AND Employees.manager_id IS NOT NULL) +ORDER BY Employees.employee_id ASC