Advertisement
hoewarden

Untitled

Sep 15th, 2019
402
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. with SubscriptionEvent(d, refunded) as
  2. (select S.date, case when R.UserId is null then 0.0 else 1.0 end from Events S
  3. left join Events R on R.customer_price < 0 and R.UserId = S.UserId and R.subscription_date = S.event_date
  4. and R.event_date <= dateadd(day, 1, S.event_date)
  5. where S.customer_price > 0)
  6. select D.d, avg(SE.refunded) from
  7. (select distinct date from Events) D
  8. join SubscriptionEvent SE on dateadd(day, 7, SE.d) >= D.d and D.d >= SE.d
  9. group by D.d
  10. order by 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement