牛客541781620号
牛客541781620号
全部文章
分类
题解(2)
归档
标签
去牛客网
登录
/
注册
牛客541781620号的博客
全部文章
(共2篇)
题解 | #未完成试卷数大于1的有效用户#
with t1 as (select job,(count(score)+1)/2 num from grade group by job) -- 取出每个job组中的中位数,5个中位数是3,4个就是2.5 select id,job,score,t2 from (select id,job,sco...
Mysql
2022-05-18
0
165
题解 | #未完成试卷数大于1的有效用户#
select uid, sum(if(submit_time is null,1,0)) incomplete_cnt, count(submit_time) complete_cnt, GROUP_CONCAT(distinct substr(start_time,1,10),':',tag se...
Mysql
2022-04-12
0
117