select

date_trunc('month', block_timestamp) as month,

count_if(

index = 0

and succeeded = TRUE

) as txns,

count(

distinct(

case

when succeeded = TRUE then value

else null

end

)

) as mau

from

solana.core.fact_transactions,

lateral flatten(input => signers)

where

block_timestamp::date >= '2024-07-01'

group by

1

),

flipside as (

select

date_trunc('month', block_timestamp) as month,

count(distinct tx_id) as txns,

count(distinct signers[0]) as mau

from

solana.core.fact_transactions

where

block_timestamp::date >= '2024-07-01'

and succeeded

group by

1