kaibladeUntitled Query
    Updated 2022-06-23
    WITH all_holders as (
    SELECT
    nft_from_address as address,
    '-1' as nft_count
    FROM ethereum.core.ez_nft_transfers
    WHERE nft_address IN (lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'),
    lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9'),
    lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523'))
    UNION ALL
    SELECT
    nft_to_address as address,
    '1' as nft_count
    FROM ethereum.core.ez_nft_transfers
    WHERE nft_address IN (lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'),
    lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9'),
    lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523'))
    )
    ,
    holders AS (SELECT
    address,
    SUM(nft_count) as holdings
    FROM all_holders
    GROUP BY address
    HAVING holdings > 0
    )

    SELECT ((SELECT COUNT(address) FROM holders WHERE holdings < 2)) AS has_one_pooly,
    ((SELECT COUNT(address) FROM holders WHERE holdings >= 2)) AS has_multiple_pooly
    UNPIVOT
    (
    NFTS for groupings in (5510, 434)

    ) as UnPvt


    Run a query to Download Data