英俊的大老虎孤寡孤寡
英俊的大老虎孤寡孤寡
全部文章
分类
题解(97)
归档
标签
去牛客网
登录
/
注册
英俊的大老虎孤寡孤寡的博客
全部文章
(共64篇)
题解 | #最差是第几名(二)#
MySQL解法: SELECT a.gradeFROM ( SELECT c.grade,c.number, SUM(c.number) OVER(ORDER BY c.grade) AS t_rank_max FROM class_grade AS c) AS aWHERE ( ...
2021-08-06
0
367
题解 | #最差是第几名(一)#
解法1:直接求和 SELECT c.grade,( SELECT SUM(d.number) FROM class_grade AS d WHERE d.grade<=c.grade) AS t_rankFROM class_grade AS cORDER BY c.grad...
2021-08-06
0
307
题解 | #实习广场投递简历分析(三)#
先找到2025年内各月的职位投递数量总和,然后寻找对应的下一年当月的投递数量之和 SELECT b.job,b.mon AS first_year_mon,SUM(b.num) AS first_year_cnt,substr(DATE(b.date,'+1 year'),1,7) AS secon...
2021-08-06
0
275
题解 | #实习广场投递简历分析(二)#
SELECT b.job,b.mon,SUM(b.num) AS cntFROM ( SELECT a.*,substr(date, 1,7) AS mon FROM resume_info AS a WHERE a.date>='2025-01-01' AND a.date...
2021-08-06
0
246
题解 | #实习广场投递简历分析(一)#
SELECT a.job,SUM(a.num) AS cntFROM resume_info AS aWHERE a.date>='2025-01-01' AND a.date<='2025-12-31'GROUP BY a.jobORDER BY cnt DESC
2021-08-06
0
269
题解 | #牛客的课程订单分析(七)#
SELECTCASEWHEN a.client_id=0 THEN 'GroupBuy'ELSE ( SELECT client.name FROM client WHERE a.client_id=client.id)ENDAS source,COUNT(a.client_id)...
2021-08-06
0
247
题解 | #牛客的课程订单分析(六)#
SELECT d.id,d.is_group_buy,CASEWHEN d.is_group_buy='Yes' THEN NULLELSE client.nameENDFROM ( SELECT c.* FROM ( SELECT b.user_id FRO...
2021-08-05
0
319
题解 | #牛客的课程订单分析(五)#
SELECT b.user_id,MIN(b.date) AS first_buy_date,( SELECT MIN(a.date) FROM order_info AS a WHERE a.user_id=b.user_id AND a.date> MIN(b.date)...
2021-08-05
0
284
题解 | #牛客的课程订单分析(四)#
SELECT a.user_id,a.first_buy_date,( SELECT COUNT(*) FROM order_info AS c WHERE a.user_id=c.user_id AND c.status='completed' AND c.product_nam...
2021-08-05
0
357
题解 | #牛客的课程订单分析(三)#
SELECT c.*FROM ( SELECT b.user_id FROM order_info AS b WHERE b.date>'2025-10-15' AND b.status='completed' AND b.product_name IN ('C++','Ja...
2021-08-05
0
263
首页
上一页
1
2
3
4
5
6
7
下一页
末页