to_address,

count(distinct from_address) as wallets,

count(distinct tx_hash) as transactions,

sum(TX_FEE) as fee_volume_eth

FROM ethereum.core.fact_transactions

WHERE TX_TYPE = 4

group by 1

order by 2 desc