SQL每日一题(20201222)求每个用户相邻两次浏览时间之差小于三分钟的次数

SQL每日一题(20210926)
SQL每日一题(20220209)
SQL每日一题(20220615)

select a.user_id,
       sum(case
               when TIMESTAMPDIFF(MINUTE, times, times2) <
                    3 then 1
               else 0 end) cnt
from (select user_id, times, lead(times) over (partition by user_id ORDER BY times) as times2 from t1222) a
GROUP BY a.user_id

select t1.user_id,
sum(case when DATE_ADD(t1.times,INTERVAL 3 MINUTE) > t2.times and t1.times < t2.times then 1 else 0 end) as cnt
from t1222 t1 left join t1222 t2
on t1.user_id = t2.user_id
group by t1.user_id