1978
查找这些员工的id,他们的薪水严格少于$30000
并且他们的上级经理已离职。
表: Employees
+-------------+----------+ | Column Name | Type | +-------------+----------+ | employee_id | int | | name | varchar | | manager_id | int | | salary | int | +-------------+----------+
select employee_id
from Employees
where salary<30000
and manager_id not in
(
select employee_id from Employees
)
order by employee_id