label_type,

count(distinct tx_id) as transactions

from solana.core.fact_events fe

join solana.core.dim_labels dl on program_id=address

where block_timestamp::date='2022-01-01'

group by 1

order by 1 asc