Paulius Alaburda

@alaburda.bsky.social

112 Followers 206 Following

Love all things R, data, medicine and energy! Head of Data Analytics @ Ignitis Lithuania 🇱🇹

with recursive recursive_cte as ( select min(events.d) as d from events union all SELECT min(recursive_events.d) as d from events recursive_events inner join (select max(d) as d from recursive_cte) latest_date on recursive_events.d > latest_date.d + 90 having min(recursive_events.d) is not null ) select events.d, case when recursive_cte.d is not null then true else false end as is_after_cooldown from events left join recursive_cte on events.d = recursive_cte.d order by events.d