select initcap(label) as platform,
count (distinct tx_id) as trxs,
count (distinct signers[0]) as users
from solana.core.fact_transactions t1 join solana.core.dim_labels t2 on t1.instructions[0]:programId = t2.address
where block_timestamp::date >= '2022-12-24'
and PRE_TOKEN_BALANCES[0]:mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
and address_name not in ('systeminstruction','token program','associated token account')
group by 1
order by 2 DESC