初级sql

1.请查出课程总成绩为160以下的学生的姓名与学生编号

select c.sid ,s.sname from (select sid, sum(score) from course group by sid having sum(score) <160) c,student s where c.sid=s.sid; 

2.请将学号小于10000的学号加上1000

update student set sid=sid+1000 where sid<10000;

3.请写出选修课程小于3门的学生的编号于学生姓名

select c.sid ,s.sname from (select sid, count(cid) from course group by sid having count(cid) <3) c,student s where c.sid=s.sid;