with top_program as (
select
program_id as address,
count(tx_id) as number_of_use
from solana.core.fact_events event
where block_timestamp::date >= '2022-01-01'
and succeeded = true
and program_id != '11111111111111111111111111111111'
group by address
order by number_of_use desc
)
select
address,
program.address_name as program_name,
top.number_of_use
from top_program top
join solana.core.dim_labels program using(address)
order by number_of_use desc