牛客404425958号

分类

/ 注册

全部文章（共214篇）

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

select name u_n, date, sum(number) over(partition by user_id order by date) from login l left join passing_number p using(user_id,date) le...

2024-10-29

0 63

每个日期新用户的次日留存率

/* with a as( select user_id, min(date) min_date from login group by user_id ), b as( select distinct date from logi...

2024-10-28

0 61

查询每个日期登录新用户个数，结果按照日期升序排序(没有记0）

/* select date, count(user_id) from (select distinct date from login) a left join (select user_id,min(date) first_date from login group by use...

2024-10-27

0 44

新登录用户的次日成功的留存率

with t as( select *, lead(date,1) over(partition by user_id order by date) nextdate from login ) select round(count(cas...

2024-10-27

0 65

每个用户最近登录日期和设备

/*先并表再筛选最近日期相关信息，较为复杂；可以先筛选最大日期信息，再并表。 1、 with t as( select * from login where id in(select id from login --无法精确对应到将每个user_i...

2024-10-27

0 48

每个用户的最近登录日期

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

2024-10-27

0 29

异常的邮件概率分组条件计数count(case when)

/*with not_blacklist as( select * from email where send_id not in (select id from user where is_blacklist=1) and receive_id not in (select...

2024-10-27

0 54

题解 | #刷题通过的题目排名#

select id, number, dense_rank() over(order by number desc) t_rank from passing_number

2024-10-27

0 53

题解 | #出现三次以上相同积分的情况#

/* with t as( select number, count(id) cnt from grade group by number ) select number from t where cnt>=3 order by number */ with t as( ...

2024-10-26

0 56

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

with t as( select first_name, rank() over(order by first_name) first_name_rank from employees order by emp_no ) select first_name from t wher...

2024-10-26

0 52