作业(平均分保留两位小数)

Discuss / SQL / 作业(平均分保留两位小数)

Back

Topic source

#1 Created at ... [Delete] [Delete and Lock User]

select class_id, round(avg(score),2) average from students group by class_id;

select class_id, gender,round(avg(score),2) average from students group by class_id,gender;