还玩d3， 你们真out (转载)# Joke - 肚皮舞运动
l*c
1 楼
EMPLOYEES BONUS
__________________________________________ _____________
EMPID NAME SUPERVISOR LOCATION SALARY EMPID NBONUS
------------------------------------------ -------------
34 Amy NY 110000 17 5000
17 Ben 34 TN 75000 10 2000
5 Chris 34 TN 80000 34 5000
10 Don 5 HI 100000 ...
1.列出每个城市，工资最高的。（工资基于萨拉瑞+包呢死）输出名字，地区，和个人
总工资
2. Given a NEW_SUPERVISOR table (columns: EMPID, SUPERVISOR), write an
update statement that updates the supervisor of each employee with a new
supervisor. The NEW_SUPERVISOR table is an incremental update, so employees
not listed in the table must retain their existing supervisor.
__________________________________________ _____________
EMPID NAME SUPERVISOR LOCATION SALARY EMPID NBONUS
------------------------------------------ -------------
34 Amy NY 110000 17 5000
17 Ben 34 TN 75000 10 2000
5 Chris 34 TN 80000 34 5000
10 Don 5 HI 100000 ...
1.列出每个城市，工资最高的。（工资基于萨拉瑞+包呢死）输出名字，地区，和个人
总工资
2. Given a NEW_SUPERVISOR table (columns: EMPID, SUPERVISOR), write an
update statement that updates the supervisor of each employee with a new
supervisor. The NEW_SUPERVISOR table is an incremental update, so employees
not listed in the table must retain their existing supervisor.
