牛客466955756号
牛客466955756号
全部文章
分类
归档
标签
去牛客网
登录
/
注册
牛客466955756号的博客
全部文章
(共29篇)
题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
select r.room_id,r.room_name,uvt.a as user_count from room_info_tb r join (select room_id,count(distinct case when out_time between '23:00:00' and '24...
2025-02-19
0
145
题解 | 被重复观看次数最多的3个视频
select l.cid,round(l.s,3) as pv,rk from (select prt.*, row_number() over (order by s desc ,release_date desc) as rk from course_info_tb ct ...
2025-02-19
0
99
题解 | 查询成绩
select count(*) from (select sId,avg(score) as a from SC where cid in (select cid from Course where cname in ('语文','数学','英语')) group by sId) b where...
2025-02-19
0
100
题解 | 网易云音乐推荐(网易校招笔试真题)
select music_name from follow f join (select * from music_likes ml join music m on m.id = ml.music_id)...
2025-02-19
0
87
题解 | 网易云音乐推荐(网易校招笔试真题)
select music_name from (select distinct music_id,music_name from follow f join (select * from music_likes ml ...
2025-02-19
0
130
题解 | 每天登陆最早的用户的内容喜好
select date(log_time) as log_day,a.user_id,ut.hobby from user_action_tb ut join (select *, rank() over (partition by date(log_time) order by lo...
2025-02-19
0
62
题解 | 统计加班员工占比
select c.department,concat(round(if(c2/c1*100,c2/c1*100,0),1),'%') as ratio from (select department,count(*) as c2 from attendent_tb a,staff_tb s wher...
2025-02-19
0
106
题解 | 更新用户积分信息?
select distinct ut.user_id,point+s as point from uservip_tb ut, (select user_id,sum(if(order_price>100,order_price,0)) as s from order...
2025-02-18
0
72
题解 | 统计用户从访问到下单的转化率
select date(visit_time) as date, concat(round(count(distinct ot.user_id) / ...
2025-02-18
40
103
首页
上一页
1
2
3
下一页
末页