case when + inner join

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