题解 | #考试分数(四)#
考试分数(四)
http://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
select job,ceiling(count(job)/2) start,floor(count(job)/2+1) end
from grade
group by job
order by job asc
考试分数(四)
http://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
select job,ceiling(count(job)/2) start,floor(count(job)/2+1) end
from grade
group by job
order by job asc
相关推荐