在之前的操作中已经定义平均成绩
create view ScoreAvg_view(学号,平均成绩) as
select 学号,avg(成绩) as 平均成绩
from CJB
group by 学号
现在需要"删除学生成绩信息视图ScoreAvg_view中平均成绩小于60分的学生信息。"
因为平均成绩是聚合函数,该怎么筛选出平均成绩<60的记录呢?
在之前的操作中已经定义平均成绩
create view ScoreAvg_view(学号,平均成绩) as
select 学号,avg(成绩) as 平均成绩
from CJB
group by 学号
现在需要"删除学生成绩信息视图ScoreAvg_view中平均成绩小于60分的学生信息。"
因为平均成绩是聚合函数,该怎么筛选出平均成绩<60的记录呢?
表数据
"studentId" "studentName" "studentAge" "studentSex" "studentDetail" "sexDouble"
"1" "aaa" "22" "1" "aaaaa" "90.00"
"2" "bbb" "33" "2" "bbbbb" "179.00"
"3" "ccc" "44" "2" "ccccc" "270.00"
"9" "阿松大" "999" "1" "阿松大" "360.00"
"10" "阿松大10" "999" "1" "阿松大10" "361.00"
"11" "张三" "22" "1" "描述" "12.50"
"20" "测试" "666" "1" "测试描述" "560.00"
"27" "测试" "666" "1" "测试描述" "500.00"
"28" "测试" "666" "1" "测试描述" "500.00"
sql 查询sexDouble平均值大于500的
SELECT studentid, studentName, AVG(sexDouble) scope FROM student GROUP BY studentName HAVING scope > 500
结果
"studentid" "studentName" "scope"
"20" "测试" "520.000000"
拼上delete