题解 | #找出待召回的流失用户#
找出待召回的流失用户
https://www.nowcoder.com/practice/74ec0a3766bf480ab7690486943678a4
with cte as (
select uid,count(*) as times,
count(distinct login_date) as days,
max(login_date) as rec_date,
max(max(login_date))over() as cur_date
from user_login_tb
group by uid )
select uid,days,times
from cte
where (times>=4 or days>=3) and datediff(cur_date,rec_date) >29
order by days desc ,times desc
投递中国石化等公司10个岗位 >
查看2道真题和解析