use EMIS
go
select teacher_id,
course_code,
avg(score) 平均分
from t_course_reg
group by
teacher_id,
course_code
go
SQL server 数据库多列分组查询
最新推荐文章于 2024-02-17 18:52:20 发布
use EMIS
go
select teacher_id,
course_code,
avg(score) 平均分
from t_course_reg
group by
teacher_id,
course_code
go