阶段三
select stuNo, stuName, stuSex, stuAge, stuSeat, stuAddress
from stuInfo where stuSex='男'
select stuNo, writtenExam
from stuMarks where writtenExam>=75 and writtenExam<=100
select AVG(writtenExam) as '笔试平均分',AVG(labExam) as '机试平均分'
from stuMarks where writtenExam<>0 and labExam<>0
select COUNT(*) as '学生总人数' from stuMarks
select COUNT(*) as '没有通过考试的人数'
from stuMarks where writtenExam between 0 and 60 or labExam between 0 and 60
select stuNo, writtenExam, labExam,(writtenExam+labExam)/2 as '平均分'
from stuMarks
select stuNo,labExam,(writtenExam+labExam)/2 as '平均分'from stuMarks
order by (writtenExam+labExam)/2 desc
阶段四
update stuMarks set writtenExam=100 where writtenExam>=95
update stuMarks set writtenExam+=5 where writtenExam<95