Fisher949
Fisher949
全部文章
分类
题解(7)
归档
标签
去牛客网
登录
/
注册
Fisher949的博客
全部文章
(共7篇)
题解 | #牛客每个人最近的登录日期(四)#
select date, if(num is null, 0, num)from( select distinct date as date from login) l2 left outer join ( select md, count(...
mysql
2021-05-06
0
352
题解 | #牛客每个人最近的登录日期(二)#
select u.name, c.name, t1.mdatefrom ( select l.user_id, l.client_id, t.mdate from login l inner join ( select user_id, ...
mysql
2021-04-25
0
374
题解 | #异常的邮件概率#
select date, round(sum(if(type='completed',0,1)) / count(*), 3)as pfrom ( select * from email where send_id in ( select id ...
mysql
2021-04-24
0
461
题解 | #查找排除当前最大、最小salary之后的员工的平均工资avg_salary#
select avg(salary) as avg_salaryfrom salarieswhere salary not in( select max(salary) from salaries where to_date='9999-01-01' union sel...
mysql
2021-04-20
0
402
no.26
SELECT e.dept_no, dept_name, title, COUNT(*) AS count FROM dept_emp e JOIN titles t ON e.emp_no=t.emp_no JOIN departments d ON e.dept_no=d.dept_no GR...
mysql
2021-04-05
0
342
no.25
SELECT t1.emp_no, t2.emp_no AS manager_no, t1.salary AS emp_salary, t2.salary AS manager_salary FROM ( SELECT d.emp_no, d.dept...
2021-04-05
0
392
no.24
SELECT dept_no, e1.emp_no, salary FROM dept_emp e1 JOIN salaries s1 ON e1.emp_no=s1.emp_no WHERE e1.emp_no IN ( SELECT e.emp_no FROM dept_emp ...
2021-04-05
0
398