event_name,

count(distinct tx_hash) as txns_count

from ethereum.core.fact_event_logs

where contract_address = '0x92d6c1e31e14520e676a687f0a93788b716beff5'

and block_timestamp > current_date - 90

and event_name is not null

group by event_name

order by txns_count desc