with t as( select '甲' name,80 grade,'A' class_name from dual union all select '乙',50,'A' from dual union all select '丙',90,'B'from dual) select class_name,sum(grade),count(name) from t group by class_name;CLASS_NAME SUM(GRADE) COUNT(NAME) ---------- ---------- ----------- A 130 2 B 90 1
select count(*) 人数, sum(分数) 总分, 班级 from tb group by 班级
with t as(
select '甲' name,80 grade,'A' class_name from dual union all
select '乙',50,'A' from dual union all
select '丙',90,'B'from dual)
select class_name,sum(grade),count(name)
from t
group by class_name;CLASS_NAME SUM(GRADE) COUNT(NAME)
---------- ---------- -----------
A 130 2
B 90 1
sum(分数) 总分,
班级
from tb
group by 班级