level 9
1、select * from students where sAddress='洛杉矶'
2、select * from students where sName like '%詹%'
3、select sID,sName from students where sAddress=!'洛杉矶'
4、select * from students where sID='学号' and sName='姓名' and sAddress='地址'
5、select * from score where cID='c001' order by score desc
6、select AVG(score) as 平均成绩,MAX(score) as 最高成绩,MIN(score) as 最低成绩 from score where cID='c002'
7、select COUNT(*) from score where cID='c002' and score>=60
8、select * from score order by cID compute avg(score) as 平均成绩 by cID
9、select sID,sName,score from score where cID in(select cID from course where cName='数据结构')
10、select sName from course where cID in(select cID from score where cID=c002 and score<80)
