牛客102435226号

分类

/ 注册

全部文章（共8篇）

题解 | 近一个月发布的视频中热度最高的top3视频

select h.video_id,round((100*h.wanbolv+5*h.dianzan_cnt+3*comment_cnt+2*retweet_cnt)/(h.wubofangtianshu+1),0) as hot_indexfrom(#计算需要的各种指标select h1.vide...

2025-03-19

0 47

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

select a.emp_id,b.emp_level,c.tag as exam_tag from (select h.emp_id,h.exam_id from (select h2.emp_id,h2.exam_id, row_number()over(partition by h2.exam...

2025-02-21

0 45

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

select h1.room_id,h2.room_name,h1.user_count from (select room_id,count(distinct user_id) as user_count from user_view_tb where substr(in_time,1,2) in...

2025-02-20

1 75

题解 | 查询成绩

select count(*) from (select h2.sname,sum(score)/3 as avg_score from (select sId,cId,score from SC ) as h1 left outer join ( select sId,sname from Stu...

2025-02-13

0 51

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

select h1.goods_id as id,h2.name,h2.weight,h1.total from (select goods_id,sum(count) as total from trans group by goods_id ) as h1 left outer join ( ...

2025-02-13

0 43

题解 | 请写出计算粉丝ctr的sql语句

select sum(h1.read_num) / sum(h1.show_num) as fans_ctr from ( select c.content_id, fans_id, show_n...

2025-02-12

0 44

题解 | #21年8月份练题总数#

select count(distinct device_id) as did_cnt,count(question_id) as question_cnt from question_practice_detail where substr(date,6,2)='08'

2024-12-02

0 52

题解 | #查询连续入住多晚的客户信息？#

select c.user_id,c.room_id,c.room_type,c.daysfrom (select b.user_id,a.room_id,a.room_type,datediff(b.checkout_time,b.checkin_time) as daysfrom checkin...

2024-08-16

0 132