case

when "number of swaps" = 1 then 'only 1 transaction'

when"number of swaps" >1 and "number of swaps" <= 3 then '1-3 transaction'

when "number of swaps" >3 and "number of swaps" <= 7 then '3-7 transaction'

when "number of swaps" >7 and "number of swaps" <= 10 then '7-10 transaction'

when "number of swaps" > 10 then 'more 10 transaction'

end as "users swap count distribution after Merge",

count("unique swappers")

from

(select

distinct ORIGIN_FROM_ADDRESS as "unique swappers",

count (*) as "number of swaps",

block_number

from ethereum.core.ez_dex_swaps

where block_timestamp >= '2022-09-15'

and block_number >= 15537394

group by 1 , 3

)

group by 1