eagle10

分类

/ 注册

全部文章（共17篇）

题解 | 每个部门薪资排名前两名员工

select department,employee_name,salary from (select department,employee_name,salary, rank() over (partition by department order by salary desc) as p...

2025-03-20

0 20

题解 | 2021年11月每天的人均浏览文章时长

SELECT DATE_FORMAT(in_time, '%Y-%m-%d') AS dt, round(sum(TIMESTAMPDIFF(SECOND, in_time, out_time))/count(distinct uid),1) AS avg_view_len_sec...

2025-03-20

0 19

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

with t1 as ( SELECT rank() over(partition by date(lb.log_time) order by lb.log_time) as paiming ,user_id,date(lb.log_time) as log_day,lb.log...

2025-03-10

0 30

题解 | 统计加班员工占比

with t1 as( select sb.department,count(*) as people from staff_tb as sb left join attendent_tb as ab on sb.staff_id=ab.staff_id group by sb.departmen...

2025-03-09

0 26

题解 | 统计商家不同会员每日访问人次及访问人数

with t1 as ( select ub.vip,count(*) as visit_nums from visit_tb as vb left join uservip_tb as ub on vb.user_id=ub.user_id group by ub.vip), t2 as (...

2025-02-16

0 37

题解 | 推荐内容准确的用户平均评分

select distinct round(avg(distinct score),3) as avg_score from recommend_tb as rb right join user_action_tb as ub on rb.rec_user=ub.user_id where rb.r...

2025-02-15

0 37

题解 | 统计各个部门平均薪资

select st.department ,avg((sb.normal_salary - sb.dock_salary)) as avg_salary from staff_tb as st left join salary_tb as sb on st.staff_id=sb.staff_...

2025-02-15

0 15