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