牛客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