这道题可以用之前的题目常用到的临时表做,十分方便 SELECT AA.emp_no ,AA.first_name ,AA.last_name ,AA.btype ,BB.salary ,round(BB.bonus, 1) FROM ( SELECT e.emp_no, e.first_name, e.last_name, eb.btype FROM employees e join emp_bonus eb on e.emp_no = eb...