signers[0] as wallet ,

sum(FEE/1e9) as amount_fee

from solana.core.fact_transactions

where block_timestamp::date>=CURRENT_DATE-30

and SUCCEEDED=false

group by 1,2

order by amount_fee DESC limit 10