牛客134017745号

分类

/ 注册

全部文章（共20篇）

题解 | 商品销售总额分布

select ( case when pay_method = '' then 'error' else pay_method end ) as pay_method, count(*) as c...

2025-04-12

0 35

题解 | 商品价格排名

with price_rk as ( select product_id, rank() over(partition by type order by price desc) as rk from product_info group by type,...

2025-04-12

0 28

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

with avg_total as ( select exam_id, avg(score) as avg_score, avg(timestampdiff(second, start_time, submit_time)) as avg_time...

2025-04-11

0 42

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

select r.room_id, r.room_name, count(distinct u.user_id) as user_count from room_info_tb r left join user_view_tb u on r.room_id = u.room_id where in...

2025-04-11

2 31

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

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

2025-04-11

0 28

题解 | 查询成绩

select count(*) from ( select sId from SC left join Course on SC.cId = Course.cId where cname in ('语文','数学','英语') group by sId ...

2025-04-11

0 30

题解 | 分析客户逾期情况

select c.pay_ability, concat(round(avg(if(l.overdue_days, 1, 0))*100, 1), '%') as overdue_ratio from customer_tb c left join loan_tb l...

2025-04-10

0 28

题解 | 最长连续登录天数

select user_id, max(consec_days) as max_consec_days from ( select user_id, count(*) as consec_days from ( select user_id, ...

2025-04-10

0 34

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

with likes as ( select user_id, music_id, music_name from music_likes left...

2025-04-09

0 32

题解 | #查找入职员工时间升序排名的情况下的倒数第三的员工所有信息#窗口函数

select emp_no, birth_date, first_name, last_name, gender, hire_date from ( select emp_no, birth_date, first_name, last_name, gender, hire_date, ...

2024-12-07

0 46