address_name,

count(distinct ORIGIN_FROM_ADDRESS) as users,

count(distinct x.tx_hash) as tx

from avalanche.core.fact_event_logs x

join avalanche.core.dim_labels y on x.contract_address=y.address

where block_timestamp>=current_date-interval '3 months'

and block_timestamp<current_date

group by 1 order by 3 desc limit 10