swaaaay

题解

未归档(36)

/ 注册

全部文章 / 题解（共10篇）

题解 | #查找所有员工的last_name和first_name以及对应的dept_name# 来自专栏

select e.last_name,e.first_name,ifnull(dep.dept_name,null) from ((employees e left join dept_emp d on e.emp_no=d.emp_no) m left join departments dep o...

Sqlite

2021-12-22

0 383

题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资# 来自专栏

SELECT t.title, avg(s.salary) FROM titles t INNER JOIN salaries s on t.emp_no=s.emp_no GROUP BY t.title ORDER BY avg(s.salary);

Sqlite

2021-12-22

0 288

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

sqlite SELECT de.dept_no,de.emp_no, max(s.salary) maxSalary FROM dept_emp de INNER JOIN salaries s ON de.emp_no=s.emp_no GROUP BY de.dept_no;

Sqlite

2021-12-15

1 270

题解 | #批量插入数据# 来自专栏

insert into actor values (1,'PENELOPE','GUINESS','2006-02-15 12:34:33'),(2,'NICK','WAHLBERG','2006-02-15 12:34:33')

Sqlite

2021-11-24

0 302

题解 | #牛客每个人最近的登录日期(二)# 来自专栏

select u.name u_n, c.name c_n, max(date) from login l inner join user u on l.user_id=u.id left join client c on l.client_id=c.id group by l.user_id ...

Sqlite

2021-11-17

0 320

题解 | #使用join查询方式找出没有分类的电影id以及名称# 来自专栏

select f.film_id, f.title from film f left join film_category fc on f.film_id=fc.film_id left join category c on fc.category_id=c.category_id where c...

Sqlite

2021-11-10

0 405

题解 | #统计各个部门的工资记录数# 来自专栏

select d.dept_no,d.dept_name, count(s.salary) from ((departments d left join dept_emp de on d.dept_no=de.dept_no) mark left join salaries s on mark.em...

Sqlite

2021-11-03

0 311

题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资# 来自专栏

select t.title title, avg(s.salary) from titles t inner join salaries s on t.emp_no=s.emp_no group by title order by avg(s.salary)

Sqlite

2021-10-27

0 362

题解 | #查找所有员工的last_name和first_name以及对应的dept_name# 来自专栏

select e.last_name,e.first_name,ifnull(dep.dept_name,null) from ((employees e left join dept_emp d on e.emp_no=d.emp_no) m left join departments dep o...

Sqlite

2021-10-27

0 393

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

SELECT d.dept_no,d.emp_no,max(s.salary) maxSalary from dept_emp d inner join salaries s on d.emp_no=s.emp_no group by d.dept_no;

Sqlite

2021-10-20

1 365