题解 | #找出待召回的流失用户#小白简化写法
找出待召回的流失用户
https://www.nowcoder.com/practice/74ec0a3766bf480ab7690486943678a4
select uid, count(distinct login_date) as days, count(id) as times from user_login_tb group by uid having datediff((select max(login_date) from user_login_tb),max(login_date))>29 and count(id)>2