[SQL문제풀기] Finding Purchases

문제

StrataScratch - Finding Purchases

StrataScratch

https://platform.stratascratch.com/coding/10553-finding-purchases?code_type=7

내가 작성한 정답

MySQL, PostgreSQL, Oracle

select distinct user_id
from (select user_id, 
        created_at-lag(created_at) over(partition by user_id order by created_at) d
      from amazon_transactions) a
where d between 1 and 7
order by 1;