select
PROJECT_NAME AS Project,
count(DISTINCT TX_HASH) AS TXns
from
base.core.fact_transactions
inner join base.core.dim_labels on address = to_address
where
block_timestamp >= timeadd('hour',-24,current_timestamp)
and LABEL_TYPE not in ('token','chadmin','operator','cex')
and STATUS='SUCCESS'
group by
1
order by
2 desc limit 10