题解 | #考试分数(四)#
考试分数(四)
http://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
SELECT job,ceil(count(*)/2) strat,floor(count(*)/2)+1 end
FROM grade
GROUP BY job
ORDER BY job
考试分数(四)
http://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
SELECT job,ceil(count(*)/2) strat,floor(count(*)/2)+1 end
FROM grade
GROUP BY job
ORDER BY job
相关推荐