muchenfeng
muchenfeng
全部文章
分类
归档
标签
去牛客网
登录
/
注册
muchenfeng的博客
全部文章
(共40篇)
题解 | 被重复观看次数最多的3个视频
select ct.cid, t2.pv, row_number() over ( order by pv desc, release_date desc ) as rk from course_...
2025-06-17
0
17
题解 | 请写出计算粉丝ctr的sql语句
select sum(IFNULL(c.read_num,0)) / sum(IFNULL(c.show_num,0)) as fans_ctr from a left join b on a.author_id = b.author_id left join c o...
2025-06-17
0
18
题解 | 请写出计算粉丝ctr的sql语句
select sum(IFNULL(c.read_num,0)) / sum(IFNULL(c.show_num,0)) as fans_ctr from a left join b on a.author_id = b.author_id left join c o...
2025-06-17
0
16
题解 | 商品交易(网易校招笔试真题)
select id,name,weight,total from goods left join ( select goods_id , sum(count) as total from trans group by goods_id having total &...
2025-06-17
0
19
题解 | 商品交易(网易校招笔试真题)
select id,name,weight,total from goods left join ( select goods_id , sum(count) as total from trans group by goods_id )t on goods.id ...
2025-06-17
0
22
题解 | 查询成绩
-- 考虑到有学生为参加考试导致分数为 NULL 的情况 SELECT count(*) FROM ( SELECT St.sId, sum(IFNULL(SC.score, 0)) / count(distinct C...
2025-06-16
0
18
题解 | 支付间隔平均值
select cast( avg( abs(timestampdiff(second, t1.logtime, t2.logtime)) ) as signed ) as gap from ( selec...
2025-06-16
0
15
题解 | 每天登陆最早的用户的内容喜好
select log_day, user_id, hobby from ( select * from ( select ...
2025-06-15
0
13
题解 | 统计加班员工占比
select department, concat( round( count(distinct IF(work_time > 9.5, staff_id, NULL)) / count(distinct staff_id) * 100,...
2025-06-15
0
23
题解 | 统计各个部门平均薪资
select t1.department,round(avg(t2.salary),3) as avg_salary from( select distinct staff_id,department from staff_tb )t1 left join( select staff_id,n...
2025-06-15
0
25
首页
上一页
1
2
3
4
下一页
末页