牛客593719959号

分类

题解(59)

/ 注册

全部文章（共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 254

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

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 310

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

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 236

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

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 372

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

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

sql

2021-09-12

0 267

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

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 249

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

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 272

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

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 239

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

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 240

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

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 293