Crazzy_Sidsuccess rate in current month
    Updated 2024-09-13
    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