牛客593719959号

题解

/ 注册

全部文章 / 题解（共56篇）

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

sql script select u.id, u.name, tmp1.grade_sum from (select user_id, rank() over(order by grade_sum desc) as g_rank, grade_sum from (select use...

sql

2021-09-12

0 338

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

sql script select u.id, u.name, tmp1.grade_sum from (select user_id, rank() over(order by grade_sum desc) as g_rank, grade_sum from (select user...

sql

2021-09-12

0 410

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

sql script select name, max(grade_sum) from (select user_id, sum(grade_num) as grade_sum from grade_info group by user_id order by ...

sql

2021-09-12

0 322

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

sql script select grade from (select grade, (select sum(number) from class_grade) as total_number, sum(number) over(order by grade) as up, sum(...

sql

2021-09-12

0 493

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

sql script select grade, sum(number) over(order by grade) as t_rank from class_grade

sql

2021-09-12

0 359

题解 | #实习广场投递简历分析(三)#

sql script -- 2025 select job, substring(date, 1, 7) as mon, sum(num) as cnt from resume_info where date like '2025%' group by job,substring(date, 1...

sql

2021-09-12

0 344

题解 | #实习广场投递简历分析(二)#

sql script select job, substring(date, 1, 7) as mon, sum(num) as cnt from resume_info where date like '2025%' group by job,substring(date, 1, 7) ord...

sql

2021-09-12

0 364

题解 | #实习广场投递简历分析(一)#

sql script select job, sum(num) as cnt from resume_info where date like '2025%' group by job order by cnt desc

sql

2021-09-12

0 343

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

sql script select coalesce(c.name, 'GroupBuy') as source, count(*) from order_info oi left join client c on oi.client_id=c.id where user_id in (sele...

sql

2021-09-11

0 337

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

sql script select oi.id, oi.is_group_buy, c.name as client_name from order_info oi left join client c on oi.client_id=c.id where user_id in (select...

sql

2021-09-11

0 392