牛客372549748号

分类

/ 注册

全部文章（共23篇）

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

select t.user_id, t.date as first_buy_date ,t.cnt from (select *,row_number() over (partition by user_id order by date ) as rk,count(product_name) ove...

2024-08-29

0 70

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

select user_id from order_info where datediff(date,'2025-10-15')>0 and product_name in('C++','Python','Java') and status='completed' group by u...

2024-08-29

0 129

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

select * from order_info where date>'2025-10-15' and status ='completed' and product_name in('C++','Python','Java') order by id asc 注...

2024-08-29

0 66

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

select t1.job,t1.first_year_mon,t1.first_year_cnt,t2.second_year_mon,t2.second_year_cnt from ( (select job,DATE_FORMAT(date,'%...

2024-08-28

0 72

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

注意1. 由2025-01-02转变成2025-02按每一个月来计算简历数量，这里就要转换date为年月的日期格式。#用DATE_FORMAT(date，format) 。format 常用的几种格式：%Y年，%m月DATE_FORMAT(date,'%Y-%m')#sqlite里面则要用str...

2024-08-28

1 66

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

select job,sum(num) as cnt from resume_info where year(date)=2025 group by job order by cnt desc 1.首先限定条件 2025年内投递简历的岗位和数量， where year(date)=20252.对岗...

2024-08-27

0 78

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

select id , name , grade_num from ( select user_id , sum(real_grade) as grade_num , DENSE_RANK() OVER(OR...

2024-08-22

0 73

题解 | #商品交易(网易校招笔试真题)#

select g.id,g.name,g.weight,a.total from goods as g inner join (select t.goods_id,sum(t.count) as total from trans t group by t.goods_id ) as a on g....

2024-08-22

0 101

题解 | #网易云音乐推荐(网易校招笔试真题)#

select music_name from music where id in (select music_id from music_likes where user_id in (select follower_id from follow where user_id=1)and music_...

2024-08-21

0 85

题解 | #今天的刷题量(一)#

select t2.name,count(subject_id) as cnt from submission as t1 left join subject as t2 on t1.subject_id=t2.id where t1.create_time= current_date group...

2024-08-17

0 63