牛客973517831号

分类

题解(7)

/ 注册

全部文章（共7篇）

题解 | #创建一个actor表，包含如下列信息#

select user.name as u_n,client.name as c_n,max(login.date) as date from login inner join user on login.user_id = user.id inner join client on login.cl...

2021-07-14

0 281

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

select d.* ,t.title ,count(title) as count from departments as d inner join dept_emp on d.dept_no = dept_emp.dept_no inner join titles as t on t.emp_...

2021-07-13

0 270

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

select t1.emp_no,de.emp_no,t1.emp_salary,salaries.salary as manager_salary from dept_manager as de inner join salaries on de.emp_no = salaries.emp_no...

2021-07-13

0 310

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

select d.dept_no,e.emp_no,s.salary from employees as e inner join salaries as s on e.emp_no = s.emp_no inner join dept_emp as d on d.emp_no = e.emp_...

2021-07-13

0 299

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

select e.emp_no,(s2-s1) as growth from employees as e inner join (select e.emp_no,s.salary as s2 from employees as e inner join salaries as s on e.em...

2021-07-13

0 278

题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#

select employees.emp_no,max(salaries.salary),employees.last_name,employees.first_name from employees inner join salaries on employees.emp_no = sala...

2021-07-12

1 282

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

select t1.dept_no,t1.emp_no,max(salary) from (select dept_emp.dept_no,dept_emp.emp_no,salaries.salary from dept_emp inner join salaries on dept_emp.e...

2021-07-12

1 287