MahrooUntitled Query
Updated 2022-07-14Copy Reference Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
--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