牛客695261949号

分类

/ 注册

全部文章（共92篇）

题解 | 查询产生理赔费用的快递信息

select e.exp_number, exp_type, claims_cost from express_tb e inner join exp_cost_tb c on e.exp_number = c.exp_number where claims_cost is not null ord...

2025-04-07

0 15

题解 | 完成员工考核试卷突出的非领导员工

select r.emp_id, emp_level , tag as exam_tag from ( select exam_id, emp_id, diff,score , avg(diff)over(partition by exam_id) as exam_diff , a...

2025-04-07

0 16

题解 | 短视频直播间晚上11-12点之间各直播间的在线人数

select t1.room_id , room_name, user_count from ( select room_id,count(distinct user_id) as user_count from user_view_tb where substr(in_time,1,2)>=...

2025-04-07

0 17

题解 | 被重复观看次数最多的3个视频

select * from ( select t2.cid,pv, row_number()over(order by pv desc, release_date desc ) as rk from ( select cid,sum(pv) as pv ...

2025-04-07

0 15

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

select music_name from follow f inner join music_likes m on f.follower_id = m.user_id inner join music mc on m.music_id = mc.id where f.user_i...

2025-04-05

0 45

题解 | 支付间隔平均值

select cast(avg(abs( timestampdiff(second,o.logtime,s.logtime)))as signed) AS gap from order_log o inner join select_log s on o.order_id = s.order_id...

2025-04-05

0 22

题解 | 统计用户获得积分

select user_id,sum(floor(timestampdiff(minute,visit_time, leave_time) /10 ) ) as point from visit_tb group by user_id order by 2 desc 小时差/10取整

2025-04-05

0 12

题解 | 统计商家不同会员每日访问人次及访问人数

select vip , count(1) as visit_nums , count(distinct t1.user_id) as visit_users from ( select user_id , substr(visit_time , 1,10) as dt from visit_tb ...

2025-04-05

0 14

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

select user_id from( select t1.user_id , substr(log_time,1,10) as dt ,row_number()over(partition by user_id order by log_time) as rn ...

2025-04-05

0 15

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

select post, round(avg(diff),3) as work_hours from ( select TIMESTAMPDIFF(MINUTE,first_clockin,last_clockin)/60 as diff,staff_id from attendent_tb whe...

2025-04-05

0 17