select a.emp_no,a.first_name,a.last_name,b.btype,c.salary,replace(format((b.btype*c.salary/10),1),',','') as bonus from employees a,emp_bonus b,salaries c where a.emp_no=b.emp_no and a.emp_no=c.emp_no and c.to_date='9999-01-01' order by emp_no