题解 | #考试分数(四)#
考试分数(四)
https://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
select
job,
FLOOR((count(job) + 1)/2) as start,
CEIL((count(job) + 1)/2) as end
from grade group by job order by job
考试分数(四)
https://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
select
job,
FLOOR((count(job) + 1)/2) as start,
CEIL((count(job) + 1)/2) as end
from grade group by job order by job
相关推荐
Rain_Codin...:没事,反正都是吹牛逼的,另一个实习生说能实习到毕业,说不定干两个月就跑了,亏的还是他