rajsMost Popular Programs Solana
    Updated 2022-07-06
    SELECT
    program_id,
    label_type,
    label_subtype,
    label,
    address_name,
    count(*) as no_of_txs
    from solana.core.fact_events e
    left join solana.core.dim_labels l
    on e.program_id = l.address
    where succeeded = 'TRUE'
    and block_timestamp >= '2022-01-01'
    -- and label_type is not null
    group by 1,2,3,4,5
    order by 6 desc
    limit 5
    Run a query to Download Data