jhonpa40MockUSDC Claimed Per Wallet
    with mock_usdc_claims as (
    SELECT
    TX_ID
    from
    solana.core.fact_events
    where
    succeeded
    and block_timestamp >= '2024-01-01'
    and program_id = 'airAGpcuhdRWpR9mqtBhmHk1bxsshEgG8ACC7nN5BY8'
    ),
    claims_as_transfers as (
    SELECT
    *
    from
    solana.core.fact_transfers
    where
    block_timestamp >= '2024-01-01'
    and mint = 'UxxvnMnUGoXJig9wc8phE1mYJZMFq3hpfr259zMWcq4'
    and TX_ID IN (
    SELECT
    TX_ID
    FROM
    mock_usdc_claims
    )
    )
    select
    tx_to as wallet_address,
    count(*) as nr_claims,
    sum(amount) as total_claimed_from_faucet
    from
    claims_as_transfers
    group by tx_to
    order by total_claimed_from_faucet