shahdadi-9ptm8Ytop 5 loser
    Updated 2022-07-10
    with a as(
    select distinct signers[0],sum(fee)/pow(10,7) fee_paid
    from solana.core.fact_transactions
    where succeeded='FALSE' and block_timestamp >= CURRENT_DATE - 365
    group by 1)
    select * from a where fee_paid > 0
    order by fee_paid desc limit 5

    Run a query to Download Data