存几分期许

分类

/ 注册

全部文章（共167篇）

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

with t_follower_id as ( select follower_id from follow where user_id=1 ) select music_name from follow a join music_likes b on a.follower_...

2025-08-08

0 48

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

select a.id, name, weight, sum(count) as total from goods a join trans b on a.id=b.goods_id where weight<50 group by a.id, name, weight having sum(...

2025-08-08

0 50

题解 | 支付间隔平均值

select cast(avg(abs(timestampdiff(second, a.logtime, b.logtime))) as signed) as gap from order_log a join select_log b on a.order_id=b.order_id

2025-08-07

0 33

题解 | 每天登陆最早的用户的内容喜好

with t as ( select user_id, log_time from ( select user_id, log_time, dense_rank() over (partition by date(log_time) order by ...

2025-08-07

0 39

题解 | 统计加班员工占比

select department, concat(round(sum(case when timestampdiff(second, first_clockin, last_clockin)/60/60>9.5 then 1 else 0 end)/count(1)*100, 1), '%...

2025-08-07

0 36

题解 | 统计各个部门平均薪资

select a.department, round(avg(normal_salary-dock_salary), 3) as avg_salary from staff_tb a join salary_tb b on a.staff_id=b.staff_id where normal_sal...

2025-08-07

0 34

题解 | 查询单日多次下订单的用户信息？

with t as ( select user_id, date(order_time) as order_date, count(1) as order_nums from order_tb group by date(order_time), user_id ha...

2025-08-07

0 39

题解 | 更新用户积分信息？

with t as ( select user_id, sum(order_price) as add_point from order_tb where order_price>100 group by user_id ) select u.user_id, ...

2025-08-07

0 23

题解 | 统计用户获得积分

select user_id, sum(floor(timestampdiff(minute, visit_time, leave_time)/10)*1) as point from visit_tb group by user_id order by point desc

2025-08-07

0 26

题解 | 统计用户获得积分

select user_id, sum(diff*1) as point from ( select user_id, floor(timestampdiff(minute, visit_time, leave_time)/10) as diff from visit_tb ...

2025-08-07

0 28