select user_id
from
(select l.user_id,date(log_time) as date,
row_number() over(partition by l.user_id order by log_time) as rk,
date_sub(date(log_time), interval row_number() over(partition by l.user_id order by log_time) day) as primary_date

from login_tb l
join register_tb r on l.user_id = r.user_id)a
group by user_id
having count(primary_date)>=3

二刷 简单