找出每个系的教师数
select dept_name ,(select count(*) from instructor where instructor.dept_name=department.dept_name) as num_instructors from department;
从Instructor关系中删除这样的元组,他们在位于Waston大楼工作。
delete from instructor where dept_name in (select dept_name from department where building='Waston');
这里先找出在Watson大楼工作的系,然后删除instructor关系中在这些系工作的老师。