select employees.emp_no, first_name, last_name, btype, salary, case when btype in (1, 2) then round(salary*btype*0.1,1) else round(salary*0.3,1)  ...