select course_id,semester,year,sec_id,avg(tot_cred)
from takes natural join student
where year=2009
group by course_id,semester,year,sec_id
having count(id)>=2
查询2009年的讲授的每个课程,并且至少有2名学生上课,找出选修该课程的所有学生的总学分的平均分
select name
from instructor
where salary>some/all(select salary
from instructor
where dept_name='Biology')
查出比生物系任意一个(全部)老师工资高的所有老师的姓名
delete from r
where p
从r表里删除条件为p的
update instructor
set salary = salary*1.05
where salary<(select avg(salary)
from instructor)
对工资低于平均工资的教师涨薪5%
update instructor
set salary= case
when salary<=100000 then salary*1.05
else salary*1.03
end
提供了顺序。工资低于10w的涨5%,高出的涨3%。