存几分期许

分类

/ 注册

全部文章（共167篇）

题解 | 考试分数(二)

select id, job, score from ( select id, job, score, avg(score) over (partition by job) as avg_score from grade ) temp where score>avg_s...

2025-08-16

0 50

题解 | 考试分数(一)

select job, round(avg(score), 3) as avg from grade group by job order by avg desc

2025-08-16

0 43

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

select name, date, sum_ from ( select user_id, date, sum(number) over (partition by user_id order by date) as sum_ from passing_number ) t...

2025-08-16

0 26

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

with t as ( select user_id, min(date) as first_login from login group by user_id ), t1 as ( select first_login, round(count(login.user...

2025-08-16

0 24

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

with t1 as ( select date, count(1) as new from ( select user_id, min(date) as date from login group by user_id ) t...

2025-08-16

0 36

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

with t1 as ( select user_id, min(date) as first_login from login group by user_id ) select round( sum(case when login.user_id is not n...

2025-08-16

0 38

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

select b.name as u_n, c.name as c_n, a.date from ( select user_id, client_id, date from login where (user_id, date) in ( select us...

2025-08-16

0 28

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

select user_id, max(date) as date from login group by user_id order by user_id

2025-08-16

0 38

题解 | 异常的邮件概率

select date, round(sum(case when type='no_completed' then 1 else 0 end)/count(1), 3) as p from email e join (select id from user where is_blacklist=0)...

2025-08-16

0 34

题解 | 找到每个人的任务

select a.id, name, content from person a left join task b on a.id=b.person_id order by a.id

2025-08-16

0 28