Careate a view of average score.创建平均分视图
来源:互联网 发布:网络奇兵 编辑:程序博客网 时间:2024/06/10 10:11
假定数据库中有三张表,student,sc,course,分别存有学生ID,学生名字;学生ID,课程ID,课程成绩;课程课程名称,现在要求求得每个学生的平均分,并创建视图,SQL代码如下:
create view Average as
select student.Name,AVG(sc.grade) AS 'Average'
from student,sc,course
where student.ID = sc.ID
and sc.CourseID = course.CourseID
group by student.name;
select student.Name,AVG(sc.grade) AS 'Average'
from student,sc,course
where student.ID = sc.ID
and sc.CourseID = course.CourseID
group by student.name;
- Careate a view of average score.创建平均分视图
- Average Score
- Creating a View Class 创建自定义视图
- ZOJ 3819Average Score (2014牡丹江现场赛A)
- Codeforce # C. Average Score
- calculate the average score
- ZOJ 3819 Average Score
- ZOJ 3819Average Score
- UVALive6969 ZOJ3819 Average Score
- 加权平均资本成本(Weighted Average Cost of Capital,WACC)
- Creating a View Class 创建一个视图类
- oracle 创建视图view
- MySQL创建View视图
- Codeforces 81 C. Average Score
- zoj 3819 Average Score(水题)
- ZOJ 3819 Average Score 水
- 【瞎搞】 ZJU 3219 Average Score
- ZOJ 3819 Average Score【水题】
- 创建一个简单的工具栏控件
- 调用getNextException查看原因
- Get the average socre of the student.(The exmaple of group, having and order by).求学生平均分(group, having 和 order by使用示例).
- java 调用系统命令获MAC、 解压缩 tar包
- Apache+Mongrel上host多个rails应用
- Careate a view of average score.创建平均分视图
- C++ qsort example.C++ 快排函数使用示例
- 详解Bash命令行处理
- 开始Python之旅!
- 读书
- 栈的表示与实现及栈的应用
- 数组的顺序表示与实现
- 关于项目管理的一点体会
- A copy program under linux.Linux下的文件拷贝工具