题解 | #考试分数(一)#
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
-- select job|avg(1.0*score) from grade group by job ;
select job , round((1.0*sum(score)/count(id) ),3) as a from grade group by job order by a desc ;
360集团公司氛围 420人发布
