1 -- how many distinct player_ids play in multiple months
6 select distinct player_id
8 where create_dt between (current_timestamp at time zone 'UTC' - interval '1 month')
9 and (current_timestamp at time zone 'UTC')
12 select distinct player_id
13 from player_game_stats
14 where create_dt between (current_timestamp at time zone 'UTC' - interval '2 month')
15 and (current_timestamp at time zone 'UTC' - interval '1 month')
18 select distinct player_id
19 from player_game_stats
20 where create_dt between (current_timestamp at time zone 'UTC' - interval '3 month')
21 and (current_timestamp at time zone 'UTC' - interval '2 month')