【解题思路】
结果保留小数点后面3位(3位之后四舍五入),使用函数round(number,digits)
*number要四舍五入的数,digits是要小数点后保留的位数
SELECT job, ROUND(avg(score),3) AS avg FROM grade GROUP BY job ORDER BY avg DESC;
【解题思路】
结果保留小数点后面3位(3位之后四舍五入),使用函数round(number,digits)
*number要四舍五入的数,digits是要小数点后保留的位数
SELECT job, ROUND(avg(score),3) AS avg FROM grade GROUP BY job ORDER BY avg DESC;