flipside

    Number of users based on transactions on Solana(Once and more than once)
    ValiMohammadiNumber of users based on transactions on Solana(Once and more than once)
    Updated 2022-07-19
    WITH t1 AS (SELECT TX_FROM AS users, COUNT(DISTINCT tx_id) as NumberOFtransaction FROM solana.core.fact_transfers
    GROUP BY 1
    )
    SELECT CASE
    WHEN NumberOFtransaction = 1 THEN 'Only one transaction (Solana)'
    WHEN NumberOFtransaction > 1 THEN 'More than one transaction (Solana)'
    END AS Description, COUNT(DISTINCT users) AS counts FROM t1
    GROUP BY 1
    Run a query to Download Data