select employees.emp_no ,first_name ,last_name ,btype ,salary,round(btype*salary/10,1) bonus from employees
join emp_bonus on employees.emp_no = emp_bonus.emp_no
join salaries on employees.emp_no = salaries.emp_no and salaries.to_date = '9999-01-01'