MLDZMNprograms1
    Updated 2023-04-11
    with t2 as (
    select
    signers[0] as users
    from solana.core.fact_events
    where program_id = '4MangoMjqJ2firMokCjjGgoK8d4MXcrgL7XJaL3w6fVg'
    )

    select
    l.LABEL as programs,
    count(distinct t.signers[0]) as sender,
    count(distinct t.tx_id) as no_txn
    from solana.core.fact_events t join solana.core.dim_labels l on t.PROGRAM_ID = l.address
    where t.block_timestamp>= '2023-01-01'
    and l.label_subtype != 'token_contract'
    and l.LABEL_TYPE in ('defi','nft','dex')
    and l.label != 'solana'
    and t.succeeded = TRUE
    and t.signers[0] in (select users from t2)
    and programs not in ('mango markets')
    group by 1
    order by 2 desc limit 10
    Run a query to Download Data