contract_address,

name,

count(distinct tx_hash) as no_of_txs,

count(distinct origin_from_address) as no_of_users

from arbitrum.core.fact_event_logs l

left join optimism.core.dim_contracts c

on l.contract_address = c.address

group by 1,2

order by 3 desc

limit 100