SELECT DISTINCT emp_no,first_name,last_name,btype,salary,(CASE WHEN btype = 1 THEN salary0.1 WHEN btype = 2 THEN salary0.2 ELSE salary*0.3 END) bonusFROM(SELECT e.emp_no,first_name,last_name,btype,salary, s.from_dateFROM employees e JOIN salaries s ON e.emp_no = s.emp_noJOIN emp_bonus eb ON e.emp_n...
投递虾皮信息等公司10个岗位 >