c#十二章上机

来源：互联网发布：知乎淘宝办公室零食编辑：程序博客网时间：2024/05/16 01:23

SELECT * FROM StuInfoSELECT * FROM StuMarksSELECT * FROM StuInfo WHERE stuSex='男'SELECT examNo,writtenExam FROM StuMarks WHERE writtenExam>75 AND writtenExam<100SELECT AVG(writtenExam) AS 笔试,AVG(labExam) AS 机试 FROM StuMarks SELECT COUNT(*) FROM StuInfoSELECT COUNT(*) FROM StuMarks WHERE labExam<60 AND writtenExam<60SELECT stuNo,writtenExam,labExam,(labExam+writtenExam)/2 AS '平均分' FROM StuMarksSELECT stuNo,(labExam+writtenExam)/2 AS '平均分' FROM StuMarks ORDER BY (labExam+writtenExam)/2 DESCUPDATE stuMarks SET writtenExam=100 WHERE writtenExam>95UPDATE stuMarks SET writtenExam=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 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