sql script
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 bonus from employees e, emp_bonus eb, salaries s where e.emp_no=eb.emp_no and e.emp_no=s.emp_no and s.to_date='9999-01-01'