participants as (

select

block_timestamp,

tx_id,

tx_from as user_address

from

solana.core.fact_transfers

where

tx_to = '9xMX57VgskjJp3ivUnkWZ4qd5is8spMBPUZCnaz3LhG7'

and mint = 'So11111111111111111111111111111111111111112'

and round(amount, 1) = 19.9

and block_timestamp between '2023-06-29 18:00:00.000' and '2023-06-30 18:00:00.000'

)

count(tx_id),

count(distinct user_address)

participants

-- SELECT

-- tx_id

-- FROM

-- solana.core.fact_events

-- where

-- succeeded

-- and program_id = 'CSGrdwbJ5z58tLGKjjcmiNMj8bG1Zazthk3cXMrbSZoX'

-- and block_timestamp::date >= '2023-06-29 18:00'

-- and instruction:accounts[13] = '86GBq99Qiuq5ZRRcq33QRBT5sM8bTUAjz7owh2BaQCRH'

-- except

-- select tx_id

-- from participants

-- select

-- *,

-- array_size(inner_instruction:instructions)

-- FROM

-- solana.core.fact_events