count (distinct tx_hash) as tx_number,

to_address as address

from ethereum.core.fact_transactions

where 1 = 1

and block_timestamp::date >= '2022-09-08'

and block_timestamp::date < '2022-09-15'

and status = 'SUCCESS'

group by address

order by tx_number desc

limit 15