Tendernessnick

分类

/ 注册

全部文章（共114篇）

题解 | 考试分数(二)

with t1 as( select id, job, score, avg(score)over(partition by job) as avg_score from grade ) select ...

2025-11-07

0 18

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

# 截至到某天总共刷了多少题 with t1 as( select user.name as name, number as pass_num, login.date as time1 # passing_number.date...

2025-11-07

0 30

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

with t1 as( select user_id, date, dense_rank()over(partition by user_id order by date) as uf from login ), t2 ...

2025-11-07

0 21

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

# 强调新用户，需要找到最早的登录日期，然后看第二天的 with t1 as( select user_id, date, min(date)over(partition by user_id) as min_date from ...

2025-11-07

0 18

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

# 每一个用户最近登录，用户名字，设备名 with t1 as( select user.name as u_n, client.name as c_n, date, dense_rank()over(partition by ...

2025-11-07

0 20

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

select distinct user_id, max(date)over(partition by user_id order by date desc) from login

2025-11-06

0 23

题解 | 异常的邮件概率

with t1 as( select send_id, u1.is_blacklist as u1b, receive_id, u2.is_blacklist as u2b, date, type...

2025-11-06

0 24

题解 | 给出employees表中排名为奇数行的first_name

with t1 as( select emp_no, first_name, dense_rank()over(order by first_name) as rank_name from employees ) se...

2025-11-06

0 22

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

select emp_no, first_name, last_name, btype, salary, ( case when btype=1 then salary*0.1 when ...

2025-11-06

0 16

题解 | 平均工资

with t1 as( select min(salary) as exp from salaries where to_date='9999-01-01' ), t2 as( select max(sa...

2025-11-06

0 15