MahrooUntitled Query
    Updated 2022-07-14
    --THE IDEA CREADITED to persian community specially HESS
    with wallet as ( select signers[0]::string as wallet , fee/pow(10,9) as Fees
    from solana.core.fact_transactions
    where block_timestamp::date >= '2022-06-01' and SUCCEEDED = 'FALSE')

    select wallet , sum(fees) as total
    from wallet
    group by 1 order by 2 desc
    limit 10
    Run a query to Download Data