题解 | #考试分数(四)#
考试分数(四)
http://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
1.SQLite解法：
SELECT g.job,(COUNT()+1)/2 AS start,COUNT()/2+1 AS end
FROM grade AS g
GROUP BY g.job
ORDER BY g.job
MySQL解法：
SELECT g.job,ceil(COUNT()1.0/2) AS start,floor(COUNT()1.0/2)+1 AS end
FROM grade AS g
GROUP BY g.job
ORDER BY g.job
华为泡池子1390人在聊
