with
main as (
select
tx_hash,
block_timestamp,
origin_from_address as user,
contract_address
from
mezo.testnet.fact_event_logs
where
tx_succeeded
)
select
contract_address,
count(distinct tx_hash) as transactions,
count(distinct user) as users
from
main
group by 1
order by users desc
limit 10