十二章 未完

/****** Script for SelectTopNRows command from SSMS  ******/SELECT TOP 1000 [stuNo]      ,[stuName]      ,[stuSex]      ,[stuAge]      ,[stuSeat]      ,[stuAddress]  FROM [stuDB].[dbo].[stuInfo]  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)  VALUES ('李文才','s25302','男',31)      INSERT INTO stuInfo (stuName,stuNo,stuSex,stuAge,stuAddress)  VALUES ('欧阳俊雄','s25304','男',18,'北京海淀')        SELECT *  FROM dbo.stuInfo    SELECT *  FROM dbo.stuInfo  WHERE stuSex= '男'      SELECT stuNo,writtenExam  FROM dbo.stuMarks  WHERE writtenExam BETWEEN 75 AND 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 /****** Script for SelectTopNRows command from SSMS  ******/SELECT TOP 1000 [examNo]      ,[stuNo]      ,[writtenExam]      ,[labExam]  FROM [stuDB].[dbo].[stuMarks]  INSERT INTO dbo.stuMarks(examNo,stuNo,writtenExam,labExam)  VALUES ('E2013120001','s25301',80,58)      INSERT INTO dbo.stuMarks(examNo,stuNo,writtenExam,labExam)  VALUES ('E2013120002','s25302',50,null)      INSERT INTO dbo.stuMarks(examNo,stuNo,writtenExam,labExam)  VALUES ('E2013120003','s25303',97,82)      SELECT *  FROM dbo.stuMarks