with platforms as ( select * from $query('798c2d2f-083d-45a4-90e3-262eb17af08f')
)
select
case when label_type is null then 'Unknown' else label_type end as "Label Type",
count(distinct FROM_ADDRESS) as address,
count(distinct tx_hash) as transactions
from ronin.core.fact_transactions a left outer join platforms b on a.to_address = b.address
where block_timestamp::date >= '2025-01-01'
and label_type not in ('operator','cex')
group by 1