SQL简单查询语句问题

SQL语句

1. 在学生表中把姓张的离校用户的年龄全部加上2岁`

 update student set sage=sage+2 where sname like '李%' and sstate=2

2. 查询年龄在15到20岁之间的的女性在校生个数

select s.* from student s,course c,sc sc where s.sno=sc.sno and sc.cno=c.cno and c.cstate=1 GROUP BY s having avg(sc.score)>60 

3. 查询王五同学学习的所有课程信息

select c.* from student s,course c,sc sc where s.sno=sc.sno and sc.cno=c.cno and s.sname='王五'

4. 查询必修课平均成绩大于60分的学生信息和平均成绩

select s.* from student s,course c,sc sc where s.sno=sc.sno and sc.cno=c.cno and c.cstate=1 GROUP BY s.sno having avg(sc.score)>60 

5. 查询课程号1的成绩比2的成绩高的所有学生的学号

select sc.sno from sc sc,sc ssc where sc.sno=ssc.sno and sc.cno=1 and ssc.cno=2 and sc.score>ssc.score