牛客468194973号

分类

/ 注册

全部文章（共8篇）

题解 | 汇总各个部门当前员工的title类型的分配数目

with t1 as (select d.dept_no, t.title, count(t.title) as count from dept_emp d left join titles t on t.emp_no = d.emp_no group by ...

2024-12-19

1 45

题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

select e_salary.emp_no, m_salary.manager_no, e_salary.emp_salary, m_salary.manager_salary from (select salaries.emp_no, ...

2024-12-19

1 68

题解 | 查找在职员工自入职以来的薪水涨幅情况

select initial.emp_no, (current_salary - initial_salary) as growth from (select e.emp_no, salary as initial_salary fro...

2024-12-18

2 56

题解 | 查询培训指定课程的员工信息

with t1 as ( select case when course like '%course3%' then 1 else 0 end as course_3, s.staff_id, s...

2024-12-17

1 39

题解 | 统计所有课程参加培训人次

select sum(0 + case when coalesce(course,'') like '%course3%' then 1 ...

2024-12-17

1 47

题解 | 分析客户逾期情况

with t1 as( select l.customer_id,l.overdue_days,c.pay_ability from loan_tb l join customer_tb c on l.customer_id = c.customer_...

2024-12-16

1 84

题解 | 每个月Top3的周杰伦歌曲

with t1 as ( select month(p.fdate) as month, p.song_id as song_id, count(p.song_id) as play_pv from play_log p...

2024-12-15

1 59

题解 | 最长连续登录天数

WITH datediff AS ( SELECT user_id, fdate, fdate - LAG(fdate) OVER (PARTITION BY user_id ORDER BY fdate) AS diff FROM tb_dau ), consecuti...

2024-12-14

1 55