Flipside TeamUsers Interaction Table
    Updated 2024-11-14
    -- forked from Users Interaction Table @ https://flipsidecrypto.xyz/edit/queries/076e7ede-1db3-496b-afe2-e7ad39364acc

    -- forked from graham / Base User Table @ https://flipsidecrypto.xyz/graham/q/lmxCVd7aq07A/base-user-table

    select
    tx_signer as "User Address",
    count(distinct project_name) as "# of Projects",
    array_agg(distinct project_name) as "Projects List"
    from near.core.fact_transactions
    inner join (select address, project_name from near.core.dim_address_labels
    where label_type not in ('token', 'cex') and label_subtype not in ('token_contract', 'nf_token_contract')
    and blockchain = 'near')
    on address = tx_receiver
    where tx_succeeded=true
    and tx_signer not in (select distinct address from near.core.dim_address_labels)
    and year(block_timestamp) >= 2023
    group by "User Address"
    having "# of Projects" >= 2
    QueryRunArchived: QueryRun has been archived