Updated 2023-05-14
    with a as
    (select buyer_address ,count(distinct tx_hash) as tx
    FROM ethereum.core.ez_nft_sales
    where EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and NFT_ADDRESS=lower('0x960b7a6bcd451c9968473f7bbfd9be826efd549a')
    group by 1)

    select
    count(distinct buyer_address) as users,
    case
    when tx = 1 then '1'
    when tx = 2 then '2'
    when tx = 3 then '3'
    when tx = 4 then '4'
    when tx = 5 then '5'
    when tx between 5 and 10 then '5 - 10'
    when tx between 10 and 15 then '10 - 15'
    when tx > 15 then 'more than 15 '
    end as "number of transactions for buyers"
    from a
    group by 2
    Run a query to Download Data