牛客695549237号

分类

/ 注册

全部文章（共4篇）

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

with a as ( -- 自己喜欢的歌 select distinct f.user_id,music_id from follow f inner join music_likes m on f.user_id = m.user_id ...

2025-05-27

0 80

题解 | 统计复旦用户8月练题情况

select device_id,university, sum(case when question_id is not null then 1 else 0 end) as question_cnt, sum(case when result = "right" then 1...

2025-05-21

0 85

题解 | 计算用户的平均次日留存率

select count(case when diff = 1 then device_id else null end) / count(device_id) as avg_ret from ( select*,(lead (date, 1) over (partition by ...

2025-05-20

0 73

题解 | 计算25岁以上和以下的用户数量

select age_cut, count(device_id) as number from ( select if (ifnull (age, 0) < 25, "25岁以下", "25岁及以上&...

2025-05-20

0 61