AyanamiAim

分类

/ 注册

全部文章（共5篇）

题解 | 连续签到领金币

-- with内容是保证同一个用户在同一天多次登录只留下签到那一次的记录 with log_info as( select uid, date(in_time) log_date, sign_in, artical_id ...

2025-03-03

1 47

题解 | 最差是第几名(二)

select grade from ( select *, min(diff) over(order by diff) min_diff from ( select g...

2025-02-25

1 40

题解 | 牛客的课程订单分析(五)

select user_id, first_buy_date, second_buy_date, cnt from ( select *, min(date) over(partition by user_id ) fi...

2025-02-25

1 43

题解 | 考试分数(四)

-- 方法1 with a as( select *, row_number() over(partition by job order by score desc,id desc) o1, row_number() over(partition by job order b...

2025-02-25

2 51

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

select distinct date, ifnull ( count( case when (user_id, date) in (select ...

2025-02-24

1 41