C#上机练习2

最新推荐文章于 2019-09-16 08:57:16 发布

原创最新推荐文章于 2019-09-16 08:57:16 发布 · 854 阅读

CC 4.0 BY-SA版权

--上机练习2

SELECT COUNT(StudentResult) AS 人数 FROM Result
SELECT SUM(ClassHour) AS 总课时 FROM Subject
SELECT SUM(StudentResult) AS 学号为s1101004 FROM Result,Grade  WHERE StudentNo='s1101004' AND GradeId=1  
SELECT AVG(StudentResult) AS 学号为s1101004 FROM Result,Grade  WHERE StudentNo='s1101004' AND GradeId=1 
SELECT MAX(StudentResult) AS 最高分,MIN(StudentResult) AS 最低分,AVG(StudentResult) AS 平均分 FROM Result,Subject WHERE ExamDate='2013-3-22'AND SubjectName='使用C#语言开发数据库应用系统'
SELECT AVG(StudentResult) AS 平均分 FROM Result,Subject WHERE StudentResult>60 AND SubjectName='使用C#语言开发数据库应用系统'
SELECT AVG(StudentResult) AS 平均分 FROM Result,Subject WHERE SubjectName='使用C#语言开发数据库应用系统'
--