SELECT aa.emp_no, aa.first_name, aa.last_name, bb.btype, cc.salary, CASE WHEN bb.btype = 1 THEN cc.salary*0.1 WHEN bb.btype = 2 THEN cc.salary*0.2 ELSE cc.salary*0.3 END bonus FROM employees aa left join emp_bonus bb on aa.emp_no=bb.emp_no left join salaries cc on aa.emp_no=cc.emp_no WHER...