MLDZMNBNM11
    Updated 2022-12-10
    with owner as (
    select * from (
    SELECT
    block_timestamp,
    tx_hash,
    TOKENID as mint,
    BUYER_ADDRESS as purchaser,
    price as amount,
    row_number() over(PARTITION BY TOKENID ORDER BY block_timestamp desc) rn
    from ethereum.core.ez_nft_sales
    where PLATFORM_NAME ='blur'
    and price_usd>0
    and amount > 0
    ) where rn = 1 order by block_timestamp desc
    )


    select
    case when bear_owned = 1 then 'a. 1 NFT'
    when bear_owned = 2 then 'b. 2 NFTs'
    when bear_owned = 3 then 'c. 3 NFTs'
    when bear_owned >= 4 then 'd. over 4 NFTs'
    end as owner_type,
    count(owner_type) as total
    from (
    select count(mint) as bear_owned,
    purchaser
    from owner
    group by purchaser
    ) group by owner_type
    Run a query to Download Data