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