Hadisehnet 4
Updated 2022-07-14
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with t1 as ( select trunc(block_timestamp,'day') as day,SUCCEEDED, fee/pow(10,8) as fees,signers[0]::string as wallet
from solana.core.fact_transactions
where SUCCEEDED in ('TRUE','False') and block_timestamp::date >= '2022-03-01'
)
select 'FAIL' as status , wallet , sum(fees) as total_fee
from t1
where SUCCEEDED = 'false'
group by 1,2
order by 2
limit 10
Run a query to Download Data