signers[0] as wallet,

sum(fee)/pow(10, 9) as fee_sol

from solana.core.fact_transactions

where date_trunc('year', block_timestamp) = '2022-01-01'

and succeeded = 'TRUE'

group by wallet

order by fee_sol desc

limit 1000