sprinkler_driver

分类

/ 注册

全部文章（共7篇）

题解 | 贷款情况

with table1(customer_id,city,loan_amount,loan_type_id,loan_type_name,cnt) as ( select l.customer_id,city,loan_amount,t.loan_type_id,t.loan_type_na...

2025-07-25

0 33

题解 | 输出播放量最高的视频

select cid,CAST(ROUND(MAX(cnt),3) AS DECIMAL(10,3)) as max_peak_uv from( select p1.id,p1.cid,count(distinct p2.uid) as cnt from play_record_t...

2025-07-23

0 39

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

with table1(department,average_actual_salary) as (select department,round(avg(normal_salary-dock_salary),2) as average_actual_salary from staff_tb joi...

2025-07-22

0 37

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

select music_name from( select m.user_id,m.music_id,music_name,rank() over(partition by music_name order by m.user_id) as rn from music_like...

2025-07-16

0 42

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

select count(if(tomorrow is not null,1,null))/count(first_day) as avg_ret from( select qpd1.device_id, qpd1.date as first_day, qpd2.date as tomorr...

2025-07-06

0 39

题解 | 浙大不同难度题目的正确率

select difficult_level, fenzi/fenmu as correct_rate from( select difficult_level,count(qpd.id) over (partition by difficult_level) as fenmu, count...

2025-07-06

0 41

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

select device_id,university,question_cnt,right_question_cnt from( select up.device_id,university,count(question_id) over (partition by device_id) ...

2025-07-06

0 28