xtu数据库原理实验（3）

实验要求前9条一条SQL完成

操作1

update INSTRUCTOR set salary=40000 where ID='99052';

//检验是否成功的语句，可以添加截图到实验报告中
select salary from INSTRUCTOR where ID='99052';

操作2

update INSTRUCTOR set salary=salary*1.1 where DEPT_NAME='Comp.Sci.';

操作3

先自查操作前Taylor楼所有的工资（不要怀疑为什么这么少，我查了下因为本身院系就很少）

select * from INSTRUCTOR where DEPT_NAME in 
(select distinct DEPT_NAME from DEPARTMENT where BUILDING='Taylor');

select DEPT_NAME from DEPARTMENT where BUILDING='Taylor';

update INSTRUCTOR set salary=salary+1000 where DEPT_NAME in 
(select distinct DEPT_NAME from DEPARTMENT where BUILDING='Taylor');

操作4