la.label_type,

la.label,

ev.program_id,

count(distinct ev.signers[0]) as users,

count(distinct tx_id) as transactions

from solana.core.fact_events ev

left join solana.core.dim_labels la

on ev.program_id = la.address

where la.label_type not in ('chadmin', 'operator', 'cex', 'nft', 'token')

and ev.block_timestamp::date >= current_date - 8

and ev.block_timestamp::date < current_date

group by 1,2,3

order by 4 desc

limit 20

;