HeminUntitled Query
    Updated 2022-11-08
    with NFT_mint_transaction as (
    SELECT *
    FROM optimism.core.fact_event_logs
    WHERE event_name = 'Transfer'
    -- AND event_inputs:from ='0x0000000000000000000000000000000000000000'
    AND event_inputs:to is NOT NULL
    -- AND event_inputs:tokenId is NOT NULL
    AND TX_STATUS = 'SUCCESS'
    ),
    active_user as (
    SELECT
    COUNT (DISTINCT TX_HASH) as active
    FROM optimism.core.fact_transactions
    ),
    mints as (
    SELECT
    COUNT(DISTINCT TX_HASH) as "Number of minter"
    FROM NFT_mint_transaction

    )
    SELECT

    (("Number of minter")/active)*100 as Percentage
    FROM mints t1 join active_user t2
    Run a query to Download Data