SELECT

COUNT(DISTINCT fe.signers[0]::STRING) AS unique_signer_count

FROM

solana.core.fact_events fe

JOIN

solana.core.ez_events_decoded ed

ON fe.tx_id = ed.tx_id

AND fe.program_id = ed.program_id

CROSS JOIN

LATERAL FLATTEN(input => PARSE_JSON(fe.inner_instruction):instructions) AS instruction

WHERE

fe.program_id = 'LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo'

AND fe.succeeded = 'true'

AND ed.event_type = 'claimFee'

SELECT

fe.block_timestamp,

fe.tx_id,

fe.succeeded,

ed.event_type,

fe.program_id,

fe.instruction,

fe.inner_instruction,

fe.signers[0]::STRING AS signer_wallet_address,

uc.unique_signer_count

FROM

solana.core.fact_events fe

JOIN

solana.core.ez_events_decoded ed

ON fe.tx_id = ed.tx_id

AND fe.program_id = ed.program_id

CROSS JOIN

LATERAL FLATTEN(input => PARSE_JSON(fe.inner_instruction):instructions) AS instruction

CROSS JOIN

unique_wallet_count uc