SELECT
label,
COUNT(DISTINCT tx_id) AS tx_count,
COUNT(DISTINCT program_id) AS program_count
from solana.core.fact_events a
JOIN solana.core.dim_labels b
on a.program_id = b.address
where label_subtype NOT IN ('general_contract', 'hot_wallet')
and block_timestamp >= '2022-01-01'
and succeeded='true'
group by 1
order by 2 desc
limit 10