牛客299852180号

分类

题解(7)

/ 注册

全部文章（共6篇）

题解 | #获得积分最多的人(三)#

分组 select user_id, sum(if(gi.type = 'add', gi.grade_num, -gi.grade_num)) grade_num from grade_info gi...

2021-06-28

1 399

题解 | #获得积分最多的人(二)#

select u.id,u.name,a.cnt from user ujoin (select user_id,sum(grade_num) cnt from grade_info group by user_id order by cnt desc) a on u.id=a.user_idjoi...

2021-06-28

1 343

题解 | #最差是第几名(一)#

select a.grade from (select (select sum(number) from class_grade) as total,grade, ROUND(@a := @a +number) num from class_grade,(select @a:=0)a order b...

2021-06-28

0 481

题解 | #牛客的课程订单分析(五)#

select user_id,substring_index(GROUP_CONCAT(date ORDER BY date ),',',1) first_buy_date, substring_index(substring_index(GROUP_CONCAT(date ORDER ...

2021-06-26

1 330

题解 | #考试分数(三)#

select aa.id,l.name,aa.score from (select g.*, @a:= if(@b =language_id,if(@c = score,@a,@a+1),1) r, ...

2021-06-23

0 332

题解 | #牛客每个人最近的登录日期(六)#

select u.name,pn.date, pn.numberfrom (select user_id,date, @r := IF(@b = user_id, @r + number, number) AS number, @b := user_id from passing_nu...

2021-06-23

1 364