1.分析
round(avg(score),3) 用来取平均后保留3位小数,
还是别忘了先对job分组,再对平均数排序。
2.代码
SELECT job, ROUND(AVG(score), 3) AS a FROM grade GROUP BY job ORDER BY a DESC
1.分析
round(avg(score),3) 用来取平均后保留3位小数,
还是别忘了先对job分组,再对平均数排序。
2.代码
SELECT job, ROUND(AVG(score), 3) AS a FROM grade GROUP BY job ORDER BY a DESC