select 'after campaign' campaign,

date_trunc (day, a.block_timestamp) as date,

count (DISTINCT a.origin_from_address) as user_no

from avalanche.core.ez_decoded_event_logs a join avalanche.core.ez_token_transfers b on a.tx_hash = b.tx_hash

where a.origin_to_address= '0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f'

and event_name = 'Swap' or event_name = 'Swapped'

group by 1,2

having date between '2023-05-21 16:00:00.000' and current_date

union all

select 'before campaign' campaign,

date_trunc (day, a.block_timestamp) as date,

count (DISTINCT a.origin_from_address) as user_no

from avalanche.core.ez_decoded_event_logs a join avalanche.core.ez_token_transfers b on a.tx_hash = b.tx_hash

where a.origin_to_address= '0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f'

and event_name = 'Swap' or event_name = 'Swapped'

group by 1,2

having date between '2023-05-10 16:00:00.000' and '2023-05-21 16:00:00.000'

order by date