hanerOwned_Fairies
    Updated 2023-07-27
    WITH
    collectors AS (
    SELECT
    BUYER AS ACCOUNT,
    SUM(COLLECTED) AS COLLECTED,
    CONCAT(
    ROUND(
    100 * (SUM(COLLECTED)) / (
    SELECT
    COUNT(DISTINCT PARAMETERS[2]:"value" [0]:"value")
    FROM
    external.tokenflow_starknet.decoded_events
    WHERE
    CONTRACT IN (
    '0x012f8e318fe04a1fe8bffe005ea4bbd19cb77a656b4f42682aab8a0ed20702f0'
    )
    ),
    2
    ),
    '%'
    ) AS PERCENTAGE
    FROM
    (
    (
    SELECT
    PARAMETERS[1]:"value" AS BUYER,
    PARAMETERS[2]:"value" [0]:"value" AS NFT_ID,
    COUNT(BUYER) AS COLLECTED
    FROM
    external.tokenflow_starknet.decoded_events
    WHERE
    CONTRACT = '0x012f8e318fe04a1fe8bffe005ea4bbd19cb77a656b4f42682aab8a0ed20702f0'
    AND NAME = 'Transfer'
    GROUP BY
    BUYER,
    NFT_ID
    Run a query to Download Data