找出所有获得奖金员工的姓名,部门,位置,城市
select last_name,departsment_name,location_id,city
from employed_id e left join departsments d
on e.departsment_id = d.departsment_id
join locations l
on l.location_id = d.location_id
where e.commision_pct is not null
找出所有获得奖金员工的姓名,部门,位置,城市
select last_name,departsment_name,location_id,city
from employed_id e left join departsments d
on e.departsment_id = d.departsment_id
join locations l
on l.location_id = d.location_id
where e.commision_pct is not null