SQL实战59.获取有奖金的员工相关信息

题目

解答

注意：case的用法
（1）case 列名 when 值 then 值
（2）case when 列名=值 then 值

select e.emp_no,e.first_name,e.last_name,eb.btype,s.salary,	
(case  when eb.btype=1 then s.salary*0.1
       when eb.btype=2 then s.salary*0.2
       else s.salary*0.3 end) as bonus
from  emp_bonus as eb left join employees as e on eb.emp_no=e.emp_no
                      left join salaries  as s on eb.emp_no=s.emp_no
where s.to_date='9999-01-01';