牛客264897283号

分类

/ 注册

全部文章（共51篇）

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

with d as ( select exam_id, avg(timestampdiff (second, start_time, submit_time)) as time_avg, avg(scor...

2025-03-10

0 72

题解 | 淘宝店铺的实际销售额与客单价

with c as ( select a.goods_id, a.user_id, a.sales_num, b.goods_price, a.sales_...

2025-03-10

0 61

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

with c as ( select room_id, count(distinct user_id) as user_count from user_view_tb wh...

2025-03-10

0 66

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

WITH c AS ( SELECT b.uid, b.cid, COUNT(b.id) AS pp FROM play_record_tb b G...

2025-03-10

0 55

题解 | 查询成绩

select count(*) from ( select sid, sum(score) as total from SC group by ...

2025-03-09

0 59

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

select sum(read_num) / sum(show_num) as fans_ctr from c c left join b b on b.content_id = c.content_id where (b.author_id, c.fans_id) ...

2025-03-09

0 74

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

select b.goods_id as id, a.name, a.weight, sum(count) as total from trans b join goods a on a.id = b.goods_id group by b.g...

2025-03-09

0 65

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

select music_name from music where id in ( SELECT DISTINCT music_id FROM music_likes ml WH...

2025-03-09

0 74

题解 | 每天登陆最早的用户的内容喜好

with a as ( select user_id, date_format (log_time, '%Y-%m-%d') as log_day, rank() over ( ...

2025-03-09

3 82

题解 | 统计加班员工占比

select a.department, concat ( round( sum( if ( timestampdiff (second, b.first_clockin,...

2025-03-09

12 56