牛客SQL练习-72-考试分数(一)

SELECT
	job,
	ROUND( AVG( score * 1.0000 ), 3 ) AS `avg` 
FROM
	grade 
GROUP BY
	job 
ORDER BY
	`avg` DESC