皮蛋瘦瘦粥

分类

/ 注册

全部文章（共27篇）

题解 | #今天的刷题量(一)#

select s2.name,s1.cnt from (select subject_id,count(id) as cnt from submission where create_time = '2023-05-17' group by subject_id) s1 left join su...

2023-05-17

0 208

题解 | #网易云音乐推荐(网易校招笔试真题)#

select music_name from music where id in (select distinct(music_id) from music_likes where user_id in (select follower_id from follow where user_id=1)...

2023-05-16

0 210

题解 | #获得积分最多的人(三)#

select u.id,u.name,g.grade_num from user u join (select a.user_id,ifnull(a.add_num-b.red_num,a.add_num) as grade_num ,dense_rank()over(order by ifnul...

2023-05-16

0 143

题解 | #获得积分最多的人(二)#

select u.id,u.name,g.grade_num from user u join (select user_id,sum(grade_num) as grade_num,dense_rank()over(order by sum(grade_num) desc ) as g_rank ...

2023-05-16

2 229

题解 | #实习广场投递简历分析(三)#

select a.job,a.first_year_mon,a.first_year_cnt,b.second_year_mon,b.second_year_cnt from (select job,left(date,7) as first_year_mon,month(date) as m,s...

2023-05-15

0 189

题解 | #牛客每个人最近的登录日期(六)#

select u.name as u_n,ps.date,ps1.ps_num from passing_number ps left join user u on ps.user_id=u.id left join (select user_id,date,sum(number)over(part...

2023-05-14

0 129

题解 | #牛客每个人最近的登录日期(五)#

select date,ifnull(round(sum(case when (user_id, date) in (select user_id,date_add(date, interval -1 day)from login) and (user_id, date) in (select u...

2023-05-12

0 167

题解 | #牛客每个人最近的登录日期(四)#

select date, sum( case when (user_id, date) in ( select user_id, m...

2023-05-11

0 170

题解 | #获取有奖金的员工相关信息。#

select e.emp_no,e.first_name,e.last_name,eb.btype,s.salary, (case btype when 1 then round(0.1*s.salary,1) when 2 then round(0.2*s.salary,1) else round...

2023-04-11

0 184

题解 | #汇总各个部门当前员工的title类型的分配数目#

select d.dept_no,d.dept_name,t.title,count(t.title) count from departments d left join dept_emp de on d.dept_no=de.dept_no join titles t on de.emp_no=...

2023-03-11

0 273