sky丶Mamba2

题解

c++(1) c语言(2) Java后端(1) mysql(2) PAT(1) PAT (Basic Level)(76) 其它(5) 大学文档(7) 数据分析(6) 社区发现(1) 算法(1)

/ 注册

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

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

最难的一个题目了： select date ,ifnull(round( sum(case when (user_id,date) in ( select user_id,min(date) from login group by user_id ) and (use...

2021-08-25

0 388

题解 | 76#考试分数(五)# 来自专栏

select id,job,score,t_rank2 from ( select * ,rank() over(partition by job order by score) t_rank1 ,rank() over(partition by job order by ...

2021-08-25

0 363

题解 | 88#最差是第几名(二)# 来自专栏

select grade from ( select grade ,(select sum(number) from class_grade) total ,sum(number) over(order by grade desc) rank1 ,sum(n...

2021-08-25

0 370

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

select round(count(*)/(select count(DISTINCT user_id) from login),3) from login where (user_id,date) in ( select user_id ,DATE_ADD(min(date...

2021-08-25

0 387

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

select t1.emp_no ,max(t2.salary-t1.salary) growth from ( select e.emp_no,salary from employees e join salaries s on e.emp_no=s.emp_no wh...

2021-08-23

0 388

题解 | 65#异常的邮件概率# 来自专栏

自己第一次做的： select t1.date,round(t2.n2/t1.n1,3) from ( select date,count(*) n1 from email e join user u1 on e.send_id=u1.id join user u2 o...

2021-08-23

0 357

题解 | 91#获得积分最多的人(三)# 来自专栏

select id ,name ,total from ( SELECT id ,name ,sum(if(type='add',grade_num,-1*grade_num)) total, rank() over(order by sum(if(ty...

2021-08-23

0 318

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

select dept_no ,no ,maxSalary from ( select dept_no ,d.emp_no no ,max(salary) maxSalary ,rank() over(partition by dept_no order ...

2021-08-22

1 307

题解 | 28#查找描述信息中包含robot的电影对应的分类名称以及电影数目，而且还需要该分类对应电影数量>=5部# 来自专栏

select name,count(f.film_id) from film_category fc join film f on fc.film_id=f.film_id join category c on fc.category_id=c.category_id where f.descri...

2021-08-22

0 397

题解 | 86#实习广场投递简历分析(三)# 来自专栏

select r1.job ,first_year_mon ,first_year_cnt ,second_year_mon ,second_year_cnt from ( select job ,left(date,7) first_year_mon ,sum...

2021-08-22

0 390