ACCP S1 SQL第十一章上机练习

最新推荐文章于 2020-08-10 16:04:20 发布

MaKube丶X

最新推荐文章于 2020-08-10 16:04:20 发布

阅读量3.1k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/baidu_36074048/article/details/53334496

本文详细介绍了ACCP S1 SQL课程第十一章的上机实践内容，包括上机2、上机3、上机4和上机5的练习题目和解题思路，旨在帮助读者巩固SQL操作技能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

上机1

select GradeId,sum(ClassHour) as 总学时数 from Subject 
group by GradeId order by sum(ClassHour)

select StudentNo,AVG(StudentResult) as '平均分' from Result
group by StudentNo

select SubjectId, AVG(StudentResult) as '平均分' from Result
group by SubjectId order by AVG(StudentResult) desc

select StudentNo,sum(StudentResult) as '总分' from Result
group by StudentNo order by sum(StudentResult) desc

上机2

select GradeId,COUNT(*)as '课程数' from Subject
group by GradeId having sum(ClassHour)>50

select GradeId,AVG(DATEDIFF(dd,BornDate,GETDATE())/365)as '平均年龄' from Student
group by GradeId

select GradeId,COUNT(*)as '学生人数' from Student
where Address like '北京%' group by GradeId

select StudentNo,AVG(StudentResult)as '平均分' from Result
group by StudentNo having AVG(StudentResult)>=60 order by AVG(StudentResult) desc

select SubjectId,AVG(StudentResult)as '平均分' from Result
where ExamDate='2013-03-22'