with solana as (

with total as (

select

'solana' as chain,

'total successful' as category,

count(1) as n_transactions

from

solana.core.fact_transactions

where

block_timestamp > current_date - 30

and succeeded = TRUE

),

complex as (

select

'solana' as chain,

'complex only' as category,

count(distinct(tx_id)) as n_transactions

from

solana.core.fact_events

where

block_timestamp > current_date - 30

and event_type not in (

'transferChecked', 'create', 'transfer',

'closeAccount','createIdempotent','initializeAccount',

'createAccountWithSeed','syncNative','advanceNonce',

'createAccount','initializeNonce','approve',

'deactivate','revoke','burn','burnChecked'

)

and event_type IS NOT NULL

and succeeded = TRUE

)

select * from total

UNION

select * from complex

),