SELECT job,ROUND(COUNT(score)/2,0), CASE WHEN COUNT(score) % 2 = 1 THEN ROUND(COUNT(score)/2,0) ELSE ROUND(COUNT(score)/2+1,0) END FROM grade GROUP BY job ORDER BY job
点赞

相关推荐

点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务