StangFASTinteractions
    Updated 2023-06-27
    -- forked from 01 @ https://flipsidecrypto.xyz/edit/queries/6b4d366b-91ba-452a-9497-1bbc059cbb00
    with
    total_user AS
    (
    SELECT
    min( a.block_timestamp ) AS date
    , a.signer_id AS users
    FROM
    near.social.fact_addkey_events a
    JOIN
    near.core.fact_transactions b
    ON a.tx_hash = b.tx_hash
    GROUP BY 2
    ORDER BY 1 DESC
    )

    SELECT
    CASE
    when users NOT IN ( SELECT DISTINCT signer_id FROM near.social.fact_decoded_actions ) then 'Not interacted' else 'Interacted'
    END
    AS type
    , count( DISTINCT users ) AS total_users
    FROM
    total_user
    GROUP BY 1
    Run a query to Download Data