BLOCK_TIMESTAMP::date date,

case when BLOCK_TIMESTAMP ilike '2022-05%' then 'May' else 'June' end as mnth,

count (distinct SWAPPER) count_swapper,

count (distinct TX_GROUP_ID) count_swaps

from flipside_prod_db.algorand.swaps

where BLOCK_TIMESTAMP ilike '2022-05%' or BLOCK_TIMESTAMP ilike '2022-06%'

group by 1,2