Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with SubscriptionEvent(d, refunded) as
- (select S.date, case when R.UserId is null then 0.0 else 1.0 end from Events S
- left join Events R on R.customer_price < 0 and R.UserId = S.UserId and R.subscription_date = S.event_date
- and R.event_date <= dateadd(day, 1, S.event_date)
- where S.customer_price > 0)
- select D.d, avg(SE.refunded) from
- (select distinct date from Events) D
- join SubscriptionEvent SE on dateadd(day, 7, SE.d) >= D.d and D.d >= SE.d
- group by D.d
- order by 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement