count(DISTINCT tx_hash) as txs

from avalanche.core.fact_transactions

join avalanche.core.ez_decoded_event_logs using(tx_hash)

where contract_address = '0x4e3535964cb5612a466d8bb25362d485452efcef'

and block_timestamp::date >= current_date - {{Last_Days}}

and event_name is not null

and status='SUCCESS'

group by 1

order by 2 desc