牛客207221769号

分类

题解(2)

/ 注册

全部文章（共57篇）

题解 | #获取有奖金的员工相关信息。#

select distinct emp_no, first_name, last_name, btype, salary, CASE WHEN btype = 1 THEN salary * 0.1 WH...

2024-02-18

0 202

题解 | #获取所有非manager员工当前的薪水情况#

select dept_no,emp_no,salary from employees join dept_emp using(emp_no) join salaries using(emp_no) where emp_no not in ( select emp_no from dept_...

2024-02-07

0 214

题解 | #对所有员工的薪水按照salary降序进行1-N#

select emp_no,salary,dense_rank()over(order by salary desc) t_rank from salaries order by t_rank,emp_no

2024-02-07

0 208

题解 | #获得积分最多的人(三)#

with t1 as( select id,name,sum(case when type = "add" then grade_num else -grade_num end) grade_num from user join grade_info o...

2024-02-07

0 195

题解 | #实习广场投递简历分析(三)#

select t1.job,first_year_mon,first_year_cnt,second_year_mon,second_year_cnt from ( select job,date_format(date,"%Y-%m") first_year_mon,s...

2024-02-07

0 211

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

select dept_no,dept_name,title,count(1) from titles left join dept_emp using(emp_no) left join departments using(dept_no) group by dept_no,title order...

2024-02-06

0 157

题解 | #获取员工其当前的薪水比其manager当前薪水#

select emp_no,manager_no,salary,manager_salary from ( select salary manager_salary,a.emp_no manager_no,dept_no from salaries a inner join dept_man...

2024-02-06

0 138

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

select emp_no,sum(diff) growth from( select emp_no,-salary diff from employees left join salaries using(emp_no) where from_date = hire_dat...

2024-02-06

0 165

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

select dept_no,emp_no,salary from( select dept_no,emp_no,salary,max(salary)over(partition by dept_no) maxSalary from dept_emp left join salar...

2024-02-05

0 143

题解 | #今天的刷题量(一)#

select name,count(1) cnt from submission left join subject on submission.subject_id = subject.id where create_time = curdate() group by subject.id,nam...

2024-02-05

0 182