刷牛客的coder很爱吃香菜

分类

/ 注册

全部文章（共22篇）

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

with t1 as ( select goods_id, sum(count) total from trans group by goods_i...

2025-02-13

0 57

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

WITH t1 AS ( -- 用户喜欢的音乐 SELECT user_id, music_id, music_name FROM music_likes ml ...

2025-02-13

0 60

题解 | 支付间隔平均值

select cast( round(avg(abs((timestampdiff (second, o.logtime, s.logtime))))) as signed ) gap from order_log o left join select...

2025-02-13

0 52

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

with t1 as ( select l.user_id, log_time, hobby, dense_rank() over ( partit...

2025-02-13

0 52

题解 | 统计加班员工占比

with t1 as ( select at.staff_id, timestampdiff (second, first_clockin, last_clockin) / 3600 work_time, ...

2025-02-13

0 44

题解 | 统计用户获得积分

with t1 as(select user_id, visit_time, truncate ( timestampdiff(second, visit_time, leave_time) / 60 / 10,0 ) vp from visi...

2025-02-12

0 42

题解 | 统计用户从访问到下单的转化率

with -- 每天的访问人数（存在一个用户在一天内多次访问的情况，需去重）） t1 as ( select date(visit_time) v_time, count(distinct user_id) v_num ...

2025-02-12

1 49

题解 | 查询连续登陆的用户

with t1 as ( select user_id, log_time, row_number() over ( partition by ...

2025-02-12

0 44

题解 | 统计各岗位员工平均工作时长

select post, avg( timestampdiff (second, first_clockin, last_clockin) / 3600 ) work_hours from staff_tb s join attendent_t...

2025-02-12

3 53

题解 | 推荐内容准确的用户平均评分

select avg(distinct score) from recommend_tb r left join user_action_tb u on r.rec_user = u.user_id where rec_info_l = hobby_l

2025-02-12

0 37