Fisher949
Fisher949
全部文章
分类
题解(7)
归档
标签
去牛客网
登录
/
注册
Fisher949的博客
全部文章
(共5篇)
题解 | #牛客每个人最近的登录日期(四)#
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
356
题解 | #牛客每个人最近的登录日期(二)#
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
380
题解 | #异常的邮件概率#
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
470
题解 | #查找排除当前最大、最小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
408
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
353