猜201812181944403
猜201812181944403
全部文章
分类
题解(3)
归档
标签
去牛客网
登录
/
注册
猜201812181944403的博客
全部文章
(共3篇)
题解 | #统计每个用户的平均刷题数#
select a.university, c.difficult_level, count(b.question_id) / count(distinct(a.device_id)) avg_answer_cnt from question_practice_detail b join user_p...
Mysql
2021-11-13
0
276
题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
SELECT f.emp_no, e.manager_no, f.salary, e.salary from (select -- 拉一张全员的薪资清单 b.emp_no, b.dept_n...
Mysql
2021-09-17
0
276
题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#
SELECT e.dept_no,d.emp_no,salary from salaries d inner join (#拉一张非管理员的员工清单 SELECT a.emp_no,b.dept_no from employees a LEFT join dept...
Mysql
2021-09-17
0
271