Crazzy_Sidsuccess rate in current month
Updated 2024-09-13
9
1
2
3
4
5
›
⌄
with a as (select count (SUCCEEDED)as true, date_trunc('day',BLOCK_TIMESTAMP) as date from solana.core.fact_transactions
where BLOCK_TIMESTAMP >= DATEADD(MONTH, -1, GETDATE()) and SUCCEEDED = 'TRUE' group by date),
b as (select count (SUCCEEDED) as false, date_trunc('day',BLOCK_TIMESTAMP) as date from solana.core.fact_transactions
where BLOCK_TIMESTAMP >= DATEADD(MONTH, -1, GETDATE()) and SUCCEEDED = 'FALSE' group by date)
select a.true, a.date,b.false from a join b on a.date=b.date
QueryRunArchived: QueryRun has been archived