牛客506681895号

分类

/ 注册

全部文章（共5篇）

题解 | 牛客每个人最近的登录日期(五)

WITH all_dates AS ( SELECT DISTINCT date FROM login ), original_query AS ( SELECT t1.date, ROUND(IFNULL(COUNT(l.user_id) / COUNT(t1.user_i...

2025-04-08

0 86

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

select t.dept_no, t.dept_name, t.title, count(t.title) as count from ( select de.*, ts.title, dm.dept_name from dept_emp de left join titl...

2025-04-08

0 81

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

select t1.emp_no, t1.manager as manager_no, t1.emp_salary, t1.manager_salary from( select de.*, s1.salary as emp_salary, dm.emp_no as ma...

2025-04-08

0 86

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

SELECT t1.emp_no, (t1.salary - t2.salary) AS growth FROM ( SELECT emp_no, salary FROM ...

2025-04-08

0 71

题解 | 获取每个部门中薪水最高的员工相关信息

WITH t1 AS ( SELECT dept_no, d.emp_no, salary FROM dept_emp d LEFT JOIN salaries s ON d.emp_no = s.emp_no ), t2 AS ( SELECT dept_no, e...

2025-04-08

0 63