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