BlockTrackertop user based on n_txs
    Updated 2023-09-03
    SELECT
    signers[0] as user,
    count(DISTINCT CASE when SUCCEEDED='true' then tx_id end ) as true_txs,
    count(DISTINCT CASE when SUCCEEDED='false' then tx_id end ) as false_txs,
    true_txs + false_txs as total_txs
    FROM solana.core.fact_events
    WHERE program_id = 'PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY'
    AND block_timestamp::date >= '2023-08-23'
    GROUP BY 1
    ORDER BY total_txs DESC


    Run a query to Download Data