flipside

    Untitled Query
    yasmin-n-d-r-hUntitled Query
    Updated 2022-07-19
    WITH whale AS (SELECT BUYER AS wallet,
    COUNT(BUYER) AS buyers,'flow' AS network
    FROM flow.core.fact_nft_sales
    GROUP BY 1,3
    UNION
    SELECT BUYER_ADDRESS AS wallet,
    COUNT(BUYER_ADDRESS) AS buyers,
    'ethereum' AS network
    FROM ethereum.core.ez_nft_sales
    GROUP by 1,3
    UNION
    SELECT PURCHASER AS wallet,
    COUNT(PURCHASER) AS buyers,
    'solana' AS network
    FROM solana.core.fact_nft_sales
    GROUP BY 1,3
    )
    SELECT network,
    COUNT(wallet) as whale_number
    FROM whale
    WHERE buyers >= '100'
    GROUP by 1
    Run a query to Download Data