十二章

来源：互联网发布：知乎淘宝办公室零食编辑：程序博客网时间：2024/04/30 08:59

阶段三+四

--2.SELECT stuNo, stuName, stuSex, stuAge, stuSeat, stuAddressFROM stuInfo WHERE stuSex='男'--3.SELECT stuNo, writtenExamFROM stuMarks WHERE writtenExam>=75 and writtenExam<=1005.SELECT AVG(writtenExam) as '笔试平均分',AVG(labExam) as '机试平均分'FROM stuMarks WHERE writtenExam<>0 and labExam<>06.SELECT COUNT(*) as '学生总人数' FROM stuMarks7.SELECT COUNT(*) as '没有通过考试的人数' FROM stuMarks WHERE writtenExam between 0 and 60 or labExam between 0 and 608.SELECT stuNo, writtenExam, labExam,(writtenExam+labExam)/2 as '平均分'FROM stuMarks9.SELECT stuNo,labExam,(writtenExam+labExam)/2 as '平均分'FROM stuMarksorder by (writtenExam+labExam)/2DESC--最后UPDATE stuMarks SET writtenExam=100 where writtenExam>=95UPDATE stuMarks SET writtenExam+=5 where writtenExam<95

阶段二

INSERT INTO stuMarks(examNo,stuNo,writtenExam,labExam)  VALUES('E2013120001','s25301',80,58)      INSERT INTO stuMarks(examNo,stuNo,writtenExam)  VALUES('E2013120002','s25302',50)      INSERT INTO dbo.stuMarks(examNo,stuNo,writtenExam,labExam)  VALUES('E2013120003','s25303',97,82)

阶段一

INSERT INTO StuInfo (stuName,stuNo,stuSex,stuAge,stuAddress )VALUES('张秋丽','s25301','男',18,'北京海淀')INSERT INTO StuInfo (stuName,stuNo,stuSex,stuAge,stuAddress )VALUES('李斯文','s25303','女',22,'河南洛阳')INSERT INTO StuInfo (stuName,stuNo,stuSex,stuAge,stuAddress )VALUES('李文才','s25302','男',31,null)INSERT INTO StuInfo (stuName,stuNo,stuSex,stuAge,stuAddress )VALUES('欧阳俊雄','s25304','男',28,'新疆克拉玛依')

0 0